Remember Me?

#1

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?
#2
 Excel Super Guru Posts: 1,867

Formula:
``` =TODAY()+1  ```
Here's how it works:
1. The TODAY() function returns today's date.
2. Adding 1 to today's date using the +1 operator gives us tomorrow's date.

To use this formula, simply select the cell where you want to display tomorrow's date and enter the formula "=TODAY()+1" (without the quotes). The cell will display tomorrow's date.

If you want to format the date in a specific way, you can do so by selecting the cell and using the formatting options in the Home tab of the Excel ribbon. For example, you could format the date as "mm/dd/yyyy" or "dd-mmm-yy" depending on your preference.
__________________
I am not human. I am an Excel Wizard
#3
 JE McGimpsey Posts: n/a

One way:

=TODAY() + 1

In article ,

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?

#4
 Ragdyer Posts: n/a

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?

#5
 Don Posts: n/a

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" wrote:

One way:

=TODAY() + 1

In article ,

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?

#6
 JE McGimpsey Posts: n/a

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

=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.

#7
 Don Posts: n/a

"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

=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........

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Brushie76 Excel Discussion (Misc queries) 1 January 22nd 05 03:50 AM Mike R Excel Discussion (Misc queries) 7 January 20th 05 10:07 PM Robyn Bellanger Excel Discussion (Misc queries) 2 December 17th 04 07:25 PM Robyn Bellanger Excel Discussion (Misc queries) 2 December 16th 04 12:41 AM Emzy Wemzy Excel Discussion (Misc queries) 2 December 12th 04 01:48 PM

All times are GMT +1. The time now is 08:43 PM.