View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bill Ridgeway Bill Ridgeway is offline
external usenet poster
 
Posts: 268
Default 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!!!!!!