Thread: Returning Yesterday
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Returning Yesterday
=TODAY()-1

"bollard" wrote:

Hello

I want my spreadsheet to return YESTERDAY's date, not TODAY's.

I believe it's not possible to embed TODAY() in a formula, so can anyone
tell me how to return YESTERDAY'S date into a cell?

Thank you.

Keith
Reply With QuoteReply With Quote