Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date in Page...
Hi guys,
Im just wondering how I can have the the time and date in a sheet.... basically im saving the sheet as a webpage.. and just want to have the time and date it was saved included.... Hope someone can help out.. Cheers.... |
#2
|
|||
|
|||
Hi
use the following UDF (only on workbook level): 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 =DOCPROPS("last save time") (format cell as date) "The Boondock Saint" wrote: Hi guys, Im just wondering how I can have the the time and date in a sheet.... basically im saving the sheet as a webpage.. and just want to have the time and date it was saved included.... Hope someone can help out.. Cheers.... |
#3
|
|||
|
|||
:) well with abit of playing around.. ive found the NOW function....
This shows the current date and time and is perfect.... im wondering is there anyway to include this into another function.. such as the CONCATENATE function Cheers "The Boondock Saint" wrote in message ... Hi guys, Im just wondering how I can have the the time and date in a sheet.... basically im saving the sheet as a webpage.. and just want to have the time and date it was saved included.... Hope someone can help out.. Cheers.... |
#4
|
|||
|
|||
Hi
try to explain what you're trying to achieve with this. Of course you could include NOW() or TODAY() in another function. e.g. ="The vcurrent date is: " & TEXT(TODAY(),"MM/DD/YYYY") "The Boondock Saint" wrote: :) well with abit of playing around.. ive found the NOW function.... This shows the current date and time and is perfect.... im wondering is there anyway to include this into another function.. such as the CONCATENATE function Cheers "The Boondock Saint" wrote in message ... Hi guys, Im just wondering how I can have the the time and date in a sheet.... basically im saving the sheet as a webpage.. and just want to have the time and date it was saved included.... Hope someone can help out.. Cheers.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
excel 2003 page numbering | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |