Formula for the Following Day
The formula -
=today()+1
will give you tomorrow's date
Regards.
Bill Ridgeway
Computer Solutions
"Anne" wrote in message
...
I type this same spreadsheet on almost a daily basis. Here is the thing,
it
is for the following day. Is there any way that I can put some kind of
formula in to get it where I do not have to type the day every single time
I
go into the spreadsheet?
For example:
Today is 7/14/06, I need to prepare this spreadsheet for about 16 people
for
their appointment the following day, and there are times when I forget to
put
the date in. So the formula would need to automatically put the date in
for
everytime the spreadsheet is opened. I do not need the time because the
times of the appointments are all different.
Please help me!!!!!!
|