Urgent Excel IF formula help!!

[Bidds10]

Hi All,

I need some urgent help with a formula please? I'm trying to complete a compliance report and a status column is driving me nuts!

this is where i am for the compliance status -

=IF(OR(P2="",U2="Active","Assigned"),"Overdue",IF(MONTH(AN2)=MONTH(TODAY()),"Approaching","In Date"))

But it is returning everything which is Status/U2 active or assigned as overdue even if the due date/AN2 is not yet due. Basically what i'm looking for is -

Overdue = If Completion Date/P2 is blank and status is active and assigned and due date/AN2 is passed today.
Approaching = If Status/U2 is "active or assigned and due date is this month
In Date = Anything which has a date in completion date/P2 and is before Due Date/AN2 is Status/U2 "complete" and/or not yet due/AN2.

Hope this makes sense!

Thanks in advance.

 

[Fluff]

Try

=IF(OR(P2="",U2="Active",U2="Assigned"),"Overdue",IF(MONTH(AN2)=MONTH(TODAY()),"Approaching","In Date"))

 

[Sufiyan97]

Try

=IF(AND(P2="",OR(U2="Active",U2="Assigned",AN2<TODAY())),"Overdue",IF(AND(OR(U2="Active",U2="assigned"),MONTH(AN2)=MONTH(TODAY())),"Approaching","In Date"))

 

[Bidds10]

Try

=IF(AND(P2="",OR(U2="Active",U2="Assigned",AN2<TODAY())),"Overdue",IF(AND(OR(U2="Active",U2="assigned"),MONTH(AN2)=MONTH(TODAY())),"Approaching","In Date"))

Thank you for the fast reply! This is still showing items with a due date in the future as overdue and also, no items as approaching.

 

[Sufiyan97]

Try

=IF(AND(P2="",OR(U2="Active",U2="Assigned"),AN2<TODAY()),"Overdue",IF(AND(OR(U2="Active",U2="assigned"),MONTH(AN2)=MONTH(TODAY())),"Approaching","In Date"))

 

[Bidds10]

Try

=IF(AND(P2="",OR(U2="Active",U2="Assigned"),AN2<TODAY()),"Overdue",IF(AND(OR(U2="Active",U2="assigned"),MONTH(AN2)=MONTH(TODAY())),"Approaching","In Date"))

This has worked! Thank you so much!

 

[Sufiyan97]

You're welcome!
Glad we could help.