Formula evaluates to true when should be false. This is a long formula, any help appreciated. The bold print is the issue.

[carpegc]

=IF(ISNA($B31),"00. Why #N/A",IF($K31="(blank)","00. In Cockpit Ready for Planning",IF(AND($P31="#",$AW31="No Confirmation Yet"),"00. In Cockpit Ready for Planning",IF(AND($P31<>"",$U31="#",OR($AW31="Not Sent to Carrier",$AW31="No Confirmation Yet")),"01. Send BR / Awaiting BC / Enter BC Details in TM",IF(AND($U31<>"",$AX31="YES"),"02. Rolled, Pending New Booking",IF(AND($AX31<>"YES",$P31<>"",$U31<>"",$AG31="NO",TEXT($AF31,"mmddyyyy")<=TEXT(TODAY(),"mmddyyyy")),"03. ["&TEXT($AF31,"yyyy - mm/dd")&"] On / Past CB/FF Doc Cut-Off",IF(AND($AX31<>"YES",$P31<>"",$U31<>"",$AG31="NO",TEXT($AF31,"mmddyyyy")>TEXT(TODAY(),"mmddyyyy")),"04. ["&TEXT($AF31,"yyyy - mm/dd")&"] Plant to Send Docs ",IF(AND($AG31="YES",$AH31="",TEXT($AD31,"mmddyyyy")<=TEXT(TODAY(),"mmddyyyy")),"05. ["&TEXT($AD31,"yyyy - mm/dd")&"] On / Past Document Cut-Off Date (FF)",IF(AND($AG31="YES",$AH31="",TEXT($AD31,"mmddyyyy")>TEXT(TODAY(),"mmddyyyy")),"06. ["&TEXT($AD31,"yyyy - mm/dd")&"] FF to Complete AES & Master SI",IF(AND($AG31="YES",$AI31="",$X31="YES"),"07. Confirm Equipment is Pre-Advised",IF(AND(AJ31<>"",$AK31="",TEXT($AJ31,"mmddyyyy")<TEXT(TODAY(),"mmddyyyy")),"08. ["&TEXT($AK31,"yyyy - mm/dd")&"] On / Past Rail Cut-Off Date",IF(AND(AJ31<>"",$AK31="",TEXT($AJ31,"mmddyyyy")>=TEXT(TODAY(),"mmddyyyy")),"09. ["&TEXT($AK31,"yyyy - mm/dd")&"] Upcoming Rail Cut-Off Date",IF(AND($AN31="NO",TEXT($AM31,"mmddyyyy")<TEXT(TODAY(),"mmddyyyy")),"10. ["&TEXT($AM31,"yyyy - mm/dd")&"] Past Cargo Cut-Off Date",IF(AND($AN31="NO",TEXT($AL31,"mmddyyyy")<=TEXT(TODAY(),"mmddyyyy"),TEXT($AM31,"mmdd")>=TEXT(TODAY(),"mmddyyyy")),"11. ["&TEXT($AM31,"yyyy - mm/dd")&"] Upcoming Cargo Cut-Off Date",IF(AND($AN31="NO",TEXT($AL31,"mmddyyyy")>TEXT(TODAY(),"mmddyyyy")),"12. ["&TEXT($AL31,"yyyy - mm/dd")&"] Upcoming Earliest Receipt Date",IF(AND($AN31="YES",$AP31="",TEXT($AO31,"mmddyyyy")<=TEXT(TODAY(),"mmddyyyy")),"13. ["&TEXT($AO31,"yyyy - mm/dd")&"] On / Past Sailing Date",IF(AND($AN31="YES",$AP31="",TEXT($AO31,"mmddyyyy")>TEXT(TODAY(),"mmddyyyy")),"14. ["&TEXT($AO31,"yyyy - mm/dd")&"] Upcoming Sailing Date",IF(AND($AP31<>"",$AR31="",TEXT($AQ31,"mmddyyyy")<=TEXT(TODAY(),"mmddyyyy")),"15. ["&TEXT($AQ31,"yyyy - mm/dd")&"] On / Past Expected Arrival Date",IF(AND($AP31<>"",$AR31="",TEXT($AQ31,"mmddyyyy")>TEXT(TODAY(),"mmddyyyy")),"16. ["&TEXT($AQ31,"yyyy - mm/dd")&"] Upcoming Expected Arrival Date",IF(AND($AR31<>"",$AV31<>"Completely processed"),"17. Vessel Arrived, POD Needed",IF(AND($AR31<>"",$AV31="Completely processed"),"18. Fully Complete & Ready to Archive")))))))))))))))))))))

 

[pecoflyer]

Without seeing a sample sheet ( no pics please), it's difficult to help

 

[Debaser]

Comparing dates that way is a strange idea as it makes month and day more important than year. So, for example, 01/01/2024 would be "less" than 12/01/1904

 

[carpegc]

I got this fixed, changing the format in column AQ to "yyyymmdd".

 

[GraH - Guido]

Switch to IFS would make this more readable too I guess.