Forum Discussion

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

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

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.