Formula to return tomorrow's date.

[Shadyhosta]

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?

 

[JE McGimpsey]

One way:

=TODAY() + 1

 

[Ragdyer]

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

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?

 

[Don]

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.

 

[JE McGimpsey]

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.

 

[Don]

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.

Absolutely correct........