"JE McGimpsey" wrote:

Hmmm...The OP said the report has to be turned in the night before, not
tomorrow.

I took the OP's request literally: "is ithere (sic) a date formula that
will return tomorrow's date to a cell in Excel?"

=TODAY()+1

does just that. Any other solution I can think of requires a manual
entry or VBA. Likewise, it assumes the report will be printed or pdf,
not delivered as an XL file.



In article ,
Don wrote:

If the report is turned in tomorrow, won't that give him the next days date
JE?

One way would be to use a macro, insert your formula, copy it, paste
special/value back in the same cell formatted as date. The date on the report
then would not change from day to day.


Absolutely correct........