View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bollard bollard is offline
external usenet poster
 
Posts: 65
Default Returning Yesterday

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