Hi,
I have a formula that I am trying to get it to return a blank if the referenced cell is blank. 03 would be a date, but if the row is blank then 03 is blank and it returns warranty expired all the way down the column. I want it to be blank until a date is entered in to cell 03.
Thanks in advance.
Debbie
=IF(TODAY()-O3>=365, "WARRANTY EXPIRED", "WARRANTY VALID")
Bookmarks