View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pasty Pasty is offline
external usenet poster
 
Posts: 95
Default 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?