I have a spreadsheet where in one column (Column A) a user needs to insert a
year end date (eg: 30/06/2002) as the starting date of the loan. Then the
years increment below - Each cell below this starting cell needs to increase
yearly for the term of the loan.
So I need calculations for if there is a leap year, etc.
I have used =A10+365 but it doesn't calculate for leap years so I have to
insert the 366 on the leap years. Is there any way to ensure this is done by
a formula?
PLEASE NOTE: We use the date formula in Australia 31/03/2002.