Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display date modified
Is there a formula that displays the date the file was last modified. I
would like a formula similar to the =now() function, except it displays the date the file was last modified (as shown in properties). Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display date modified
'----------------------------------------------------------------- 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 such as =DocProps ("last author") or =DocProps ("last save time") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Curious" wrote in message ... Is there a formula that displays the date the file was last modified. I would like a formula similar to the =now() function, except it displays the date the file was last modified (as shown in properties). Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display date modified
In the cell you want the message displayed enter the formula -
=TODAY() Format that cell as custom and, in 'type', enter "The message you want displayed" dd/mm/yyyy You will also need to make sure the spreadsheet is updated manually. To do this- Click on <Tools<Options<Calculations<Manual Regards. Bill Ridgeway Computer Solutions "Curious" wrote in message ... Is there a formula that displays the date the file was last modified. I would like a formula similar to the =now() function, except it displays the date the file was last modified (as shown in properties). Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date display | Excel Discussion (Misc queries) | |||
How to return a value between date ranges | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
i want to display the month from a date into another cell | Excel Worksheet Functions | |||
Modified Date | New Users to Excel |