Formula to return tomorrow's date.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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 said:
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
Click to expand...
Excel?
 
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.
 
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.
 
JE McGimpsey said:
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.
Click to expand...

Absolutely correct........
 
Back
Top