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

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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

ChemistB

Hi Jason,

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

Babs