Thread
:
how do i add 1 year to a date formatted cell?
View Single Post
#
3
William
Posts: n/a
Hi rogerm
This formula will add one year to the date in cell A1. Replace the "+1" in
the formula with the number of years you want to add.
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
--
XL2003
Regards
William
"Rogers" wrote in message
...
I would like to increase the year in a MM/DD/YYYY formated cell by 1, 2,5
and
10 and place the new dates in other cells. Adding 365 doesn't work
because
of leap years. Any suggestions?
Reply With Quote