"Dennis" <Dennis@[EMAIL PROTECTED]
> wrote in message
news:D420CB05-7C1A-4F55-B971-77A0750F833A@[EMAIL PROTECTED]
>I am looking for a formula that I can enter into a spreadsheet that will
>show
> what the last date the file was modified on. I have reveiwed all
formulas
> listed in the Help area but have not found one. Any ideas?
What's wrong with just putting =TODAY() in a cell and ensuring that
autocalc
is enabled?
Anytime the file is modified, it will be stored with the current date.
The filesystem time stamp is also a great way to determine this fact also.
--
Lawrence Garvin, M.S., MCBMSP, MCTS, MCP
Senior Data Architect, APQC, Houston, Texas
Microsoft MVP - Software Distribution (2005-2008)
MS WSUS Website: http://www.microsoft.com/wsus
My Websites: http://www.onsitechsolutions.com;
http://wsusinfo.onsitechsolutions.com
My MVP Profile: http://mvp.sup****t.microsoft.com/profile/Lawrence.Garvin


|