Today minus 1 day

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

Guest

What is the formula for current date, minus one day?

Thank you so much!
 
Try this:

=TODAY()-1

Remember to format the result as a date.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
duh. (!) As soon as I saw your answer, I felt really silly. Thank you SO
much!
 
You must log in or register to reply here.

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

Todaysdateminus1and2 3
Rounding date field up to next first of month, with existing formu 5
#NAME? Error 3
Date calculation 1
Time attendance calculation problem 1
What's the best way to set this formula up? 0
Average Length of Stay 2
Amend year 4

Back
Top