LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Please can someone look at question i posted yesterday jimE Excel Worksheet Functions 2 October 23rd 07 10:27 PM
I really need help. Need a formula. Need it yesterday. Dennis New Users to Excel 1 March 12th 07 08:53 PM
continuation from yesterday Mindy Excel Discussion (Misc queries) 4 June 22nd 06 11:13 PM
Need absolute time from yesterday MIke K Excel Worksheet Functions 4 January 21st 05 04:30 PM
Message for Frank follow on Q from yesterday Ajay Excel Discussion (Misc queries) 1 December 9th 04 04:38 PM


All times are GMT +1. The time now is 10:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"