LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mo Mo is offline
external usenet poster
 
Posts: 69
Default last date saved in excel

Hello,
I am trying to place the last date saved in an excel spreadsheet. For
instance, if I last saved a document a month ago, and I open the document
today, I want a month ago's day to print out not today's date UNLESS I SAVE
the document.

I know this can be done in MS Word through Insert Field, choosing date and
format and preserving formatiing during updates but I cannot for the life of
me figure out how to do this in Excel.

The closest I can come is header/footer and putting date in format there but
it doesn't give me the last date I saved.

Can you help?
--
Thank you for your help
MO
Albany, NY
 
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
Can I Add the last saved Date to cell ref in excel? Angela Excel Discussion (Misc queries) 3 November 15th 07 10:50 AM
show last date saved in excel k2224z Excel Discussion (Misc queries) 2 August 29th 06 04:57 PM
Display Last Saved Date Excel JonniP Excel Discussion (Misc queries) 1 October 6th 05 02:58 PM
How do I display the last saved date in an EXCEL spreadsheet? Andrea Excel Discussion (Misc queries) 1 March 10th 05 08:55 PM
Last saved date into an excel cell Steve J. Vaughan Excel Worksheet Functions 2 December 13th 04 11:17 AM


All times are GMT +1. The time now is 08:25 PM.

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

About Us

"It's about Microsoft Excel"