Date plus 1 year (february problem)
Hi Everyone,
I want to compute date + 1 year, I am using the following:
=DATE(YEAR(C5)+1,MONTH(C5),DAY(C5))
My problem is when C5 is 2-29-2004, I get a result of 3-1-2005, when I want
2-28-2005.
I've tried playing around with my formula for a date minus 3 month's post
but can't adapt it.
=MIN(DATE(YEAR(C5),MONTH(C5)+{-2,-3},DAY(C5)*{0,1}))
Any ideas?
|