If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2003
Can anyone help me please! I am faced with the dilemma of how to
automatically refresh the date as the Sales Engineers update their reports. I entered the formula =today() but it does not reflect the date when their report was really updated? I am to eliminate cheating on their reporting. I truly appreciate any answer to my query. Lilian |
#2
|
|||
|
|||
Excel 2003
Wouldn't the file modified date be what you want?
Lilian wrote: Can anyone help me please! I am faced with the dilemma of how to automatically refresh the date as the Sales Engineers update their reports. I entered the formula =today() but it does not reflect the date when their report was really updated? I am to eliminate cheating on their reporting. I truly appreciate any answer to my query. Lilian |
#3
|
|||
|
|||
Excel 2003
Using VBA you can grab the "last save time" from document properties.
Where would you like this placed? The code below stored in Thisworkbook module will give you last save time in activesheet A1...............edit to suit or post back for more help. Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, _ Cancel As Boolean) ActiveSheet.Range("A1") = "Last Saved : " & _ Format(ThisWorkbook.BuiltinDocumentProperties _ ("Last Save Time"), _ "yyyy-mmm-dd hh:mm:ss") End Sub Gord Dibben MS Excel MVP On Mon, 16 Nov 2009 09:16:02 -0800, Lilian wrote: Can anyone help me please! I am faced with the dilemma of how to automatically refresh the date as the Sales Engineers update their reports. I entered the formula =today() but it does not reflect the date when their report was really updated? I am to eliminate cheating on their reporting. I truly appreciate any answer to my query. Lilian |
#4
|
|||
|
|||
Excel 2003
Lillian,
try the formula = NOW() this should update your date field -- Jeff Sydney, Australia "Lilian" wrote: Can anyone help me please! I am faced with the dilemma of how to automatically refresh the date as the Sales Engineers update their reports. I entered the formula =today() but it does not reflect the date when their report was really updated? I am to eliminate cheating on their reporting. I truly appreciate any answer to my query. Lilian |
#5
|
|||
|
|||
Excel 2003
And in what way does the date given by =NOW() differ from the date given by
=TODAY(), Jeff? The only difference is that =NOW() includes the time as well as the date. In either case the date will be updated whenever the worksheet recalculates, so it doesn't meet the OP's requirement.. -- David Biddulph "Etz99" wrote in message news Lillian, try the formula = NOW() this should update your date field -- Jeff Sydney, Australia "Lilian" wrote: Can anyone help me please! I am faced with the dilemma of how to automatically refresh the date as the Sales Engineers update their reports. I entered the formula =today() but it does not reflect the date when their report was really updated? I am to eliminate cheating on their reporting. I truly appreciate any answer to my query. Lilian |
Thread Tools | |
Display Modes | |
|
|