How do I insert date modified in an Excel document?
 

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.

Modification date of what? The workbook? A cell?

What formula in Word?


--
Lilliabeth
------------------------------------------------------------------------
Lilliabeth's Profile: http://www.excelforum.com/member.php...o&userid=27741
View this thread: http://www.excelforum.com/showthread...hreadid=476405

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?

--
Regards,
Fred


"Josh Brewster" <Josh wrote in message
...
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.

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

"Fred Smith" wrote:

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?

--
Regards,
Fred


"Josh Brewster" <Josh wrote in message
...
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.

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.

In article ,
"Josh Brewster" <Josh wrote:

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.

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)

--
Regards
Frank Kabel
Frankfurt, Germany

--
Gary''s Student


"Josh Brewster" wrote:

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.

you mean Ctrl &;