Time Stamp Assistance

[Kevin]

Hi Folks,

I am trying to set up a time stamp ala the one in the attached file. I want to be able to do things
a) once Column B is populated then the time stamp activates.
b) If Column B cell is empty(it will have a drop-down control for populating), then the column A should stay blank.

Thanks in advance

Kind Regards

Kev

 

[Logit]

Formula : =IF(B2="","",TEXT(TODAY(),"d-mmmm-yyyy") & " " & TEXT(NOW(),"h:mm AM/PM"))

Refer to attached

 

[Kevin]

Thank you, works perfectly. I see where I was going wrong.

 

[Logit]

You are welcome.

 

[GraH - Guido]

And when the workbook recalculates, is the time stamp not updated?
You might need to activate iterative calculations. (check the checkbox)

Then you can use this in A2: =IF(B2="","",IF(A2<>"",A2,NOW()))
Is somewhere explained on the blog of .