how to compute the interest during years that have leap years within the period concerned.

[Robert Salonikios]

I am looking for a financial/mathematical formula (or array) whereby the calculation of interest varies in case the base year happens to be a leap year (within the period considered).
I am presenting my query through the attached excel worksheet whereby the variable data to be inserted are in cells A1 to D1.
The idea is to make sure that if there is a leap year within the time period (cells C1:D1) then the computations during this period are based on 366 days and not 365.
My attached excel is limited to a period (D1 minus C1) of 8 years otherwise I would have to expand my formulae beyond column O. This is a limiting factor but this at least serves my current needs.
I would appreciate any assistance to make my process simpler through a formula (array) or a macro.
Thank you.

 

[Robert Salonikios]

E1 not change, only code:

 For i = StartD.Value2 +1 To EndD.Value2

Thank you

 

[Robert Salonikios]

That worked perfectly well as the Start Date is now counted in.

For example, if StartD is 12/3/2022 and EndD is 13/3/2022, then the UDF computes on the basis of the EndD-StartD = 2 days (not 1 day) as I need to include the day within the OPENING StartD and the day within the CLOSING EndD.

Thank you

 

[bebo021999]

You may need:

 For i = StartD.Value2 +1 To EndD.Value2+1

 

[Robert Salonikios]

You may need:

 For i = StartD.Value2 +1 To EndD.Value2+1

THANKS