Date Formatting
 

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.

Date Formatting
 

See this previous post with a similar question.
http://www.microsoft.com/office/comm...e-29c3bb4e1fdf
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Eán" wrote:

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.

Date Formatting
 

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.

--
Alan Moseley IT Consultancy
http://www.amitc.co.uk

If I have solved your problem, please click Yes below. Thanks.


"Eán" wrote:

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.