I assume that you want the date to remain static after entry.

Easiest way, use 2 cells.

Format the cell that's to display the date as you wish, then enter this
formula:

=A1+1
With A1 representing a cell where you can easily enter:
<Ctrl < ; , (that's a semicolon).

You could format that A1 cell to be "white on white", so it wouldn't be
visible.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Shadyhosta" wrote in message
...
I have a report that must be turned in the night before for tomorrow's
date.
Is ithere a date formula that will return tomorrow's date to a cell in
Excel?