Hi All
I need a time stamp(NOW()) in P:3 (d/m/yy h:mm AM/PM) if there is any change in B3:L3
I need to run this formula down the whole work sheet for this columns
The formula I attempted to use,
=COUNTIF(B3:K3,"DONE")
then
=IF(O3>0,NOW(),"")
ALL the dates in P change to current date and time if any cells are changed ,not just the cell in P corresponding to the changed cell in B3:L3
Thankyou for having a look
I need a time stamp(NOW()) in P:3 (d/m/yy h:mm AM/PM) if there is any change in B3:L3
I need to run this formula down the whole work sheet for this columns
The formula I attempted to use,
=COUNTIF(B3:K3,"DONE")
then
=IF(O3>0,NOW(),"")
ALL the dates in P change to current date and time if any cells are changed ,not just the cell in P corresponding to the changed cell in B3:L3
Thankyou for having a look