To return the Current Date + 1 Day use
=Today() + 1
To return the Current Date + 1 Year
=DATE(YEAR(TODAY()) +1,MONTH(TODAY()),DAY(TODAY()))
You mention that it has to account for leap years. What do you mean by
that? If you replace the +1 with +3 in the formula above to add three
years to today (and thus cross over 2008 which is the next leap year)
the date returned is 7/27/09. Is this not the answer you are looking
for?
scott56hannah Wrote:
Would also be helpful if there were similar formulae that would provide
the
ability to either add 1 day or add 1 year to the current date......Of
course
it needs to take into account leap years and other problems.....can
anyone
help
--
Excelenator
------------------------------------------------------------------------
Excelenator's Profile:
http://www.excelforum.com/member.php...o&userid=36768
View this thread:
http://www.excelforum.com/showthread...hreadid=565827