Hi,
I have a worksheet with 2 columns column a "status" and the other column B "date" what I want is whenever the contents in column a change and the entry ="Completed" the date is input into the corresponding cell in column B, I have been using the formula; =IF(A2="Complete",TODAY(),"") however when the day changes this no longer works, Any help would be most appreciated.