View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MB MB is offline
external usenet poster
 
Posts: 53
Default Today minus 1 day

duh. (!) As soon as I saw your answer, I felt really silly. Thank you SO
much!
--
MB


"Ron Coderre" wrote:

Try this:

=TODAY()-1

Remember to format the result as a date.

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

XL2002, WinXP


"MB" wrote:

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

Thank you so much!
--
MB