Trying to get the next date exactly 5 years ago..
I use the following function(s) in a list of dates (ascending, obviously) to
=VLOOKUP(DATE(YEAR(NOW())-5;MONTH(NOW());DAY(NOW()));$A:$A;1)
This gives me either today, or the last occurance of the same day 5 years
ago if today is not available. I know what causes this, but can anybody give
me a not too complicated formula for getting the next one?
Thanks a lot!
Mike
|