Robert Salonikios
New Member
- Joined
- Jun 23, 2005
- Messages
- 13
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.
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.