Forum Discussion

Addie800's avatar
Addie800
Copper Contributor
Sep 14, 2023

Need Assitance With Formula

Hi I have an Excel table that tracks projects. The columns in the table are name of project, team mate assigned, status, and due date. I would like to create an if statement function that would be based on the due date of a project. If the due date is  three days away from todays date (ex: due date June 10, and it is June 7), then the cell in the status column would say high priority. Any suggestions on how to write this formula? I would appreciate any assistance thank you!

excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Sep 14, 2023

    Addie800 

    Depends on how many statuses you have. In simplest  case in Status column it could be

    =IF( (DueDate - TODAY() <=3)*(DueDate.TODAY() ), "High priority", "Nothing critical" )

    It's better if you give more details how the data is structured on on which Excel platform/version you are.

Resources