Need help with IFs ANDs and Dates!!

[MrCrimmy]

Hello Everyone!!

I was hoping I might get some help regarding an issue I'm having with IF statements as a function of date.

So I'm working on a project reporting tool that has all of the projects for my department and their status, be it Ready, Not yet due, due withing two weeks or late. The function I've been using is as follows:

=IF(AND(ISBLANK(E16)=FALSE,ISBLANK(F16)=FALSE,ISBLANK(G16)=TRUE,$A$10>F16),"Late",IF(ISBLANK(G16)=FALSE,"Ready",IF(AND(ISBLANK(E16)=FALSE,(F16>($A$10+14))=FALSE,ISBLANK(G16)=TRUE,($A$10+14)>F16),"Due within two weeks","Not yet due")))

Where

A10 = todays date
E16 = start date
F16 = due date
G16 = completion date

I need to add in more arguments and I really don't know how, my end goal is to have a "Ready", "due immediately" (within one week) "due within two weeks" ( < 14 days from due date), "due within a month" (<30 days to due date) "not yet due" (> 30 days to due date) and "Late".

I have no idea how to put in so many arguments and I am very lost.

If anyone could help I would greatly appreciate it.

Kind Regards,

Bryan

 

[CROY1985]

It looks like you may be overcomplicating your IF statement, try this and let me know which if any scenarios it doesn't work:

=IF(ISBLANK(G10),IF(A10>F10,"Late",IF(F10-A10>30,"Not Due Yet",IF(F10-A10>14,"due in Month",IF(F10-A10>7,"due in 2 weeks","Due Immediately")))),"Ready")

 

[Andrew Poulsom]

To allow for blanks in column F:

=IF(ISNUMBER(G16),"Ready",IF(ISNUMBER(F16),IF(F16<$A$10,"Late",IF(F16<($A$10+7),"Due immediately",IF(F16<($A$10+14),"Due within two weeks",IF(F16<($A$10+30),"Due within one month","Not yet due")))),""))

 

[MrCrimmy]

Thank you both very much, they both work perfectly!

I really appreciate your help on this! Have a great day!!