Talk About Network

Google





Software > Cert Officespecialist > Re: Excel Sprea...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 3 Topic 754 of 840
Post > Topic >>

Re: Excel Spreadsheet - File info

by "Lawrence Garvin" <onsite@[EMAIL PROTECTED] > Jan 11, 2008 at 08:25 PM

"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
 




 3 Posts in Topic:
Excel Spreadsheet - File info
=?Utf-8?B?RGVubmlz?= <  2008-01-11 06:14:03 
Re: Excel Spreadsheet - File info
"Lawrence Garvin&quo  2008-01-11 20:25:32 
Re: Excel Spreadsheet - File info
"TK [MCSE,MCT]"  2008-01-21 19:31:05 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Fri Jan 9 20:49:19 PST 2009.