Help with a Formula

New Contributor

I need to have a cell populate another cell only when the date of a different cell is greater than a date from another cell.  Ex:  cell C4 needs to copy over to cell I4 when the date in cell b4 is greater than 180 days from the date in cell h1.  

2 Replies
best response confirmed by Hans Vogelaar (MVP)



You can try this formula.

help with a formula.JPG 

This is perfect. Thank you so very much.