Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting for cell date to equal today's date | Excel Worksheet Functions | |||
Formatting as date | Excel Worksheet Functions | |||
Date Formatting (*) | Excel Discussion (Misc queries) | |||
Formatting Date | Excel Discussion (Misc queries) | |||
date formatting | Excel Discussion (Misc queries) |