Date Formatting

E

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.
 
A

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.
 
Top