Help with a Formula

[kfish1000]

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 · Accepted solution]

@kfish1000 

=IF(B4>$H$1+180,C4,"")

You can try this formula.

 

[#3]

This is perfect. Thank you so very much. :)