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

Yes, "=today+1" without quote marks.

Yes, guess how

=TODAY()+1

If you only want working days, then use

=WORKDAY(TODAY(),5)

as an example.

--
HTH

Bob Phillips

"Donnie" wrote in message
...
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

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

Donnie,

=TODAY()+1, the parenthesis must be included.

Regards,
A

"cgarrett1999" wrote:

Yes, "=today+1" without quote marks.

Thanks very much Aristotle.
Very helpful.

Another quick question. Can you do week commencing?
ie As today is Tuesday, could you do a function that takes today and returns
the monday of that week?

THanks
Donnie

"aristotle" wrote:

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

=TODAY()-WEEKDAY(TODAY()-2)

--
HTH

Bob Phillips

"Donnie" wrote in message
...
Thanks very much Aristotle.
Very helpful.

Another quick question. Can you do week commencing?
ie As today is Tuesday, could you do a function that takes today and
returns
the monday of that week?

THanks
Donnie

"aristotle" wrote:

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