Hello all!
I have two cells that I am working with: C5 and H5.
C5 contains a date that I manually enter.
H5 needs to look at that date and decide wether it is more than 60 days older than the current date. This is the formula that I have for it in cell H5:
=IF(((C5+60)>TODAY()),"DELETE","")
This code does exactly what I need for it to do. The only problem with it is that if there is no date entered into cell C5, H5 displays "DELETE". If there is no data entered into cell C5 I want the cell that the function is in to be empty. How do I do this?
Thanks in advance for everything!
Bookmarks