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
Bennadeau's avatar
Bennadeau
Iron Contributor
Sep 15, 2020

Hi casino123,

You were soooo close... Just remove the quotes in the if false section...

=IF(ISBLANK(N8),"ASAP",DATE(YEAR(N8)+5,MONTH(N8), DAY(N8)))

 

  • 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