Date Formatting

[Eán]

Is there a way like in Word I can have a cell in excel which will show the
date the worksheet was last updated?

Please and thank you.

 

[Luke M]

See this previous post with a similar question
http://www.microsoft.com/office/com...&p=1&tid=51be9c02-b847-414c-9dee-29c3bb4e1fdf

 

[Alan Moseley]

Hold down ALT and hit F11. Insert a new Module and pase the following code
into it:-

Public Function LastModified()
LastModified = Format(FileDateTime(ThisWorkbook.FullName), "dd/mm/yy hh:nn")
End Function


On you spreadsheet click in the cell you want the date to appear and type
the following into the formula bar:-

=LastModified()

That should just about do it.