Forum Discussion

anncshaw's avatar
anncshaw
Copper Contributor
Jul 28, 2021
Solved

Excel IF formula

Hi I am trying to do an if formula as follows:   Delivery Date            Due Date          Status 25/07/2021               28/07/2021       01/07/2021               05/07/2021 01/01/1970       ...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Jul 28, 2021

    anncshaw 

    In Status

    it could be

    =IF( [@[Delivery Date]]=DATE(1970,1,1), "Open",
 IF( [@[Delivery Date]]<[@[Due Date]], "Early",
 IF([@[Delivery Date]]>[@[Due Date]], "Later", "On time")))
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 28, 2021

anncshaw 

In Status

it could be

=IF( [@[Delivery Date]]=DATE(1970,1,1), "Open",
 IF( [@[Delivery Date]]<[@[Due Date]], "Early",
 IF([@[Delivery Date]]>[@[Due Date]], "Later", "On time")))
  • anncshaw's avatar
    anncshaw
    Copper Contributor
    Jul 29, 2021
    Amazing thank you!!!!!!

Resources