AppGini Community Forums

Code: Select all

// Define start and end dates

$startdate='2021-05-12';
$enddate='2023-09-24';

$start_date = new DateTime($startdate);
$end_date = new DateTime($enddate);

// Define interest rates for each year
$interest_rates = [
    2021 => 3.50,
    2022 => 2.94,
    2023 => 4.87
];

// Initialize total interest
$total_interest = 0;

// Calculate interest for each year
foreach ($interest_rates as $year => $rate) {
    // Calculate the number of days in the year
    $year_start = new DateTime("$year-01-01");
    $year_end = new DateTime("$year-12-31");
    if ($year == $start_date->format('Y')) {
        $year_start = max($year_start, $start_date);
        $year_end = min($year_end, new DateTime("$year-12-31"));
    } elseif ($year == $end_date->format('Y')) {
        $year_start = max($year_start, new DateTime("$year-01-01"));
        $year_end = min($year_end, $end_date);
    }
    $interval = $year_start->diff($year_end);
    $days_in_year = $interval->days + 1;

    // Calculate interest for the year and add it to the total
    $year_interest = ($rate / 365) * $days_in_year;
    $total_interest += $year_interest;
}

// Display the total interest
echo "Total interest: $total_interest";  // maybe you want to round the result