How do I insert date modified in an Excel document?

J

Josh Brewster

I'm not getting this - how come I can't insert a date modified in an Excel
document? In Word, it is really simple; the formula is a built - in feature.
 
F

Fred Smith

We need to know what you mean by "insert a date modified".

Entering the current date is easy: Use Ctrl-:

Excel also has several date functions, include =Date(year, month, day)

Does any of this help?
 
J

Josh Brewster

What I need is a field that shows when the date was last modified, or saved.
If you look in an Excel spreadsheet's properties, you'll see Date Created,
Date Modified, Date Accessed. I'm interested in inserting "Date Modified."

Must admit I'm not that great at Excel - thanks for any info you can provide!

jb
 
J

JE McGimpsey

What aren't you getting? XL and Word have different built-in features.
The vary from version to version as well.

There are a myriad number of ways to "insert a date modified" in XL -
depending on what you mean. Do you mean a date when any particular cell
is modified? See

http://www.mcgimpsey.com/excel/timestamp.html

Do you mean a date when *any* cell is modified? You could modify the
macro at the above site, or search the archives for any number of
alternative solutions:

http://groups.google.com/advanced_group_search

Use *excel* in the group field.
 
G

Gary''s Student

Frank Kable posted this several days ago:



Hi
use the following UDF:

Function DocProps(prop As String)
application.volatile
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
(prop)
Exit Function
err_value:
DocProps = CVErr(xlErrValue)
End Function

and enter in a cell
=DOCPROPS("last save time")
(format cell as date)
 
Top