Getting a false from formula

Luis

You haven't provided a result for the FALSE part of the last IF and when that's the case Excel will return FALSE.

Ah I see that......question for row 2.  On row 2 that one should say On time since both the change_del_date and the cur_plnd_date is in the future and not blank.

Original question for which I provided the formula:

https://www.experts-exchange.com/questions/29109707/Calculating-status-based-on-multiple-dates.html

Is the data correct on that line?

Planned Del Date  - 25 December 2018
Confirmed Del Date - 26 January 2018; that is 11 months earlier, maybe should be 26 January 2019.

Data os correct....with your previous formula it gives me "FALSE" results as well.....

If still not working, can you supply a list of ALL scenarios that could occur, such as below, with their status results:

PLAN_DEL_DATE      CONF_DEL_DATE      CHANGED_DEL_DATE      CUR_PLND_DEL_DATE
PAST                              PAST                              PAST                              PAST
FUTURE                        FUTURE                        FUTURE                        FUTURE
FUTURE                        PAST                              FUTURE                        FUTURE
PAST                              PAST                              FUTURE                        FUTURE

Line 3 is your scenario in the latest sample.

Please also clarify where a Del Date that is equal to today would fall; PAST or FUTURE?

Attached is a revised criteria.....to make it easier,,,I would only need "PAST DUE" OR "ON-TIME".   No need to inlcude "LATE"

Please see atachment....
C--Users-lfreund-Desktop-DATE---FAL.xlsx

Hi Luis,

If you only need "PAST DUE" or "ON-TIME", what are the rules for "PAST DUE" and "ON-TIME"?
Also, can you justify the desired output you showed in column T based on those rules?

Attached are the new rules for each "PAST DUE" AND "ON-TIME"
C--Users-lfreund-Desktop-Past-Due.xlsx

The explanation you added in column H is like a puzzle and I am not sure if I understood it clearly. :)

If you use Office 365 or Office - 2016, try the below formula...

=IF(AND(MAXIFS(E2:F2,E2:F2,"<>")<TODAY(),MINIFS(C2:F2,C2:F2,"<>")<TODAY()),"PAST DUE","ON-TIME")

Select allOpen in new window

Thanks.  I'm getting a #NAME? error.  

Also I'm open for suggestions on how to simplify this....I'm sure I'm making it more compicated than it should really be.....

Probably the MAXIFS function. Only came with Excel 2016

Did the the trick....works great.

Thanks Gents for all the help!

You're welcome Luis! :)