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!!!!!!