Hi,

Yes you can add x days onto a date and it will increase correctly.
Alternatively you could use the DATE() function e.g.
=DATE(YEAR(B2),MONTH(B2),DAY(B2)+1) where B2 hosts the date driving the
requirements.

BTW - There are a number of handy functions within the analysis toolpak:

Go to: Tools - Addin - Analysis Toolpak.

Handy functions for instance a

EOMONTH() -- Returns the serial number for the last day of the month that is
the indicated number of months before or after start_date.

EDATE() -- Returns the serial number that represents the date that is the
indicated number of months before or after a specified date (the start_date).

WEEKNUM() -- Returns the day of the week (1;2;3;4;5;6;7) corresponding to a
date.

Use the help feature to grasp a more detailed understanding of these and
many more.

Regards,
A

"Donnie" wrote:

I would like to set up a formula that produces the date for tomorrow, the
next day and so on... I am fine with the TODAY function, but can you make a
formula that uses today's date and projects forward from there?
Any help would be greatly appreciated.
Thanks