Date

J

Jacob Skaria

=today()-1
=today()+1

Format it to your required format

If this post helps click Yes
 
B

Bernard Liengme

=TODAY()-1 and =TODAY() + 1
Of course, when you open the file tomorrow they will display new dates.

To enter today's date as a constant use CTRL+; (this will not update)

best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
Formatting templates 7
Autofill Date in Word 15.33 for Mac 0
MS Project. Real progress of the project, % complete 1
Yield to Maturity 10
Countdown macro - display settings 2
display date of today in cell X when number >0 in cell Y 2
How to automate update on weekly reports spreadsheet 0

Top