Date and text movement
=IF(O2=P2,AND(P2,J2&" "&K2),P2)
I want my register to put a date in to a field if its done on time (there
will be a planned date already specified) and also move text from one cell
and add it onto another one to show that it has been carried out and no
longer needs actioning
Can this be done?
|