maybe an OR formula?

cmautry · May 14, 2021

Please help if you can. I'm sure this is much easier than I think. I need help with a formula in "D"

A - Date of Placement	B - Date Plan Due	C - Date Plan Approved	D - Review Due
1/1/2021	this is the date in "A" +45	this is a date or the cell is blank	I need either the date in C +150 OR if the C is blank, I need something like "Out of Compliance"

Does this make sense? Can anyone help?

Thanks!
Christina Autry
Chandler, TX

AliGW · May 15, 2021

Maybe a simple IF:

=IF(C1="","Out of Compliance",C1+150)