Changing Date in one cell based on text in another cell
Is there a formula to change the date in a cell in one column to the date in another column on the same row based on the text in a third cell on the same row? For example, I want the date in G3 to change to the date in J3 when the text in H3 says Completed.
February 19th, 2015 6:06pm

Hi,

My understanding is that if the value of H3 is "Completed", the G3 is changed the value of J3, is it correct? If yes, we can use If formula (=IF(H2="completed",J2)), please see the image below:

If no, please share us a sample, we'd like to re-try it.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
February 19th, 2015 11:34pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics