Well..., consider the following suggestions in order to avoid the need for
VBA Macros.
1) Press: CTRL+; [CTRL+semicolon] to insert todays Date as TEXT.
2) If the cell already uses has the NOW() or TODAY() function - select that
cell press [F9] and then [Enter].
Micky


"totally lost" wrote:

I use the formula =TODAY() often. But I want to know what to use when I want
to autodate today then when I go back into the worksheet tomorrow I want it
show yesterday's date not todays. Does that make any sense, lol