Home

Multiple Date Issues

FU_SU_LU
Occasional Visitor

Is there a way to have both text AND the correct date in the same cell without it changing the date to a bunch of numbers?

 

Also, is there a way to have excel show the correct dates in the spreadsheet, while also being correct when you have to print that specific day?  I can't use the =today() function+1,+2,+3, etc.  It shows the correct dates in the spreadsheet, but when you get to Thursday, it'll be a few days ahead.

 

Many thanks!

1 Reply

In your sample file, we can edit the formula in Cell A1, as follows: 

="SHIP LOG / PACKING LIST FOR: "&
TEXT(TODAY(),"m/d/yyyy")

If you wish to add days to the date today, the formula

=TODAY()+1 will return the serial number of the date tomorrow because dates are stored as serial numbers (starting with 1 representing the date "01-Jan-1900"), although they may be formatted as dates or presented as text. 

To add 1 day to the date today and present it as text, the formula is: 

=TEXT(TODAY()+1,"dd-mmm-yyyy"). 

Remember that TODAY is a volatile function that recalculates everyday. If you need to enter the static date for today, you may do so with the shortcut key: Ctrl+;

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
W10-1903 UNC path failing 0x80070043
kurgan in Windows Insider Program on
80 Replies