Excluding the leap year in a date formula

Hi there,

I have a series of random dates e.g.
1 Feb 08
20 March 08
12 April 08
and so on.

Each date represents the beginning of a lease.
Each lease finishes in exactly 10 years time.
Rather than manually typing the date 10 years from now for each date, I'd like a formula which will calculate this and simply copy it down.
The problem with the formula below is that leap years are not taken in consideration.
=B4 + (365*10)

Does anybody know a formula which would exclude leap years from a calculation?

Thanks,
Babs

Hi, Babs. Here is an easier solution:

=DATE(YEAR(B4)+10,MONTH(B4),DAY(B4))

If by some chance a lease starts on 2/29 of a leap year, it will end on 3/1.

HTH

Jason

Hi Jason,

Thanks for your reply. Sorry for my very very later reply.

Babs

If your initial dates are in column A starting with row 2, then in B2

=A2+3650

3650 is the number of days in 10 standard years.

Is that what you need?

ChemistB

Ahh, my mistake. My formula is the same as your original one. I read the post incorrectly. Make sure your analysis Toolpak addin is included and you can use this formula

=EDATE(A2,120)

ChemistB