SOLVED

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)
Solution

@kfish1000 

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

You can try this formula.

help with a formula.JPG 

This is perfect. Thank you so very much.