Hi there,

I have a problem to calculate the year in between dates. It is easy to get the days, but I need to devide an USD amount over the certain period and need to reflect how much money I need to pay per year. So the question is:

How much money do I need to pay per year between 01/01/2010 and 31/12/2019 if the total amount during the period is USD 10,485,223.00?

Initially I could just work with the general value of 365,25 days a year like this:

A1: 01/01/2010
A2: 31/12/2019
A3: 10,485,223.00
A4: =A2-A1 resulting in 3651 days
A5: =(A2-A1)/365,25 resulting in 10,00 years
A6: =A3/((A2-A1)/365,25) resulting in USD 1,048,953.08 per year.

but this is not correct because its not 365,25 days during that period but the average year comes to 365,2 days (I manually did a average calculation with the relevant leap years 2012+2016)

How can I consider the leap years in my calculation? i.e. the bolt value needs to be somehow a calculated average of the days per year during the A1&A2 period.

Woudl apprecaite your help.

Brgds
Kai