Can you do a function like =TODAY() PLUS 1?

D

Donnie

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
 
B

Bob Phillips

Yes, guess how

=TODAY()+1

If you only want working days, then use

=WORKDAY(TODAY(),5)

as an example.
 
A

aristotle

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 are:

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
 
D

Donnie

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
 
Top