Static date stamp

[excelnewb_1]

Hi everyone,

Please, please, please someone help me.

I'm having a problem getting a static date stamp using TODAY() to not update every time I open the spreadsheet. I basically need a cell to time stamp when another cell is marked "approved" and I need this to work for the entire column. I'm currently using the formula:

=IF(U4=" ", " ",IF(U4="Approved",TODAY(),IF(U4="Denied",TODAY())))

As I'm sure most of you know, the TODAY() function automatically updates to "today"'s day whenever you open the spreadsheet. Is there any way around this? I need to be able to track when these things are approved and so I need to record the dates.

Any help is tremendously appreciated.

Thanks!

- Justin

[ARGK]

Hi
Have a look at this lnk:

http://www.excelforum.com/excel-form...cent-cell.html

Good luck.
Tony

[sktneer]

See if you get any help or clue from the code given below......

Please Login or Register  to view this content.

Alternatively you can use the following code for worksheet Change Event. The benefit of this code would be, it will only update the date values for the rows for which you will change the values of column U and the remaining rows will contain the unchanged previous dates.

Please Login or Register  to view this content.