Forum Discussion

casino123's avatar
casino123
Copper Contributor
Sep 15, 2020

Need an IF formula with a date

I'm looking for the following formula to help with dates and deadlines: If the cell is blank, write "ASAP". If it's not blank, add 5 years to the date in the cell.    Cell 1 would be: 1/1/2005 It...
excel
Formulas and Functions
casino123's avatar
casino123
Copper Contributor
Sep 15, 2020

Bennadeau Thanks! That works when it's blank, but when there's a date, it says "Invalid Call Reference Error." Do you know what that means?

Bennadeau's avatar
Bennadeau
Iron Contributor
Sep 15, 2020

casino123 

Look at the attached spreadsheet. 

It works fine on my end. I did had to format cell "O8" as date.

  • casino123's avatar
    casino123
    Copper Contributor
    Sep 15, 2020

    Bennadeau Thank you, once I formatted it as a date, it worked great! Thanks!!!

Resources