IF - Date Range

A Rose

Hi,

Can you help me with a formula for the below argument?

IF Created@row is more than 28 days In the past, "4 Weeks Overdue", IF Created@row is more than 35 days In the past, "5 Weeks Overdue"

Thank you!

Bassam Khalil

Hi @A Rose

Hope you are fine, please try the following formula :

=IF(AND(Created@row <= TODAY(-28), Created@row > TODAY(-35)), "4 Weeks Overdue",
 IF(Created@row <= TODAY(-35), "5 Weeks Overdue", ""))

the following screenshot shows the result:

Bassam Khalil

Hi @A Rose

Hope you are fine, please try the following formula :

=IF(AND(Created@row <= TODAY(-28), Created@row > TODAY(-35)), "4 Weeks Overdue",
 IF(Created@row <= TODAY(-35), "5 Weeks Overdue", ""))

the following screenshot shows the result:

A Rose

Hi @Bassam Khalil ,

That was a big help!

Can we go a little further?

we now have 4 weeks and 5 weeks overdue,

I want to add when "6 Weeks Overdue" and when "More than 6 weeks overdue"

Is that possible?

Thank you!

Bassam Khalil

@A Rose

Please try the following formula :

=IF(AND(Created@row <= TODAY(-28), Created@row > TODAY(-35)), "4 Weeks Overdue",
 IF(AND(Created@row <= TODAY(-35), Created@row > TODAY(-42)), "5 Weeks Overdue",
 IF(AND(Created@row <= TODAY(-42), Created@row > TODAY(-48)), "6 Weeks Overdue",
 IF(Created@row <= TODAY(-48), "More than 6 weeks overdue"))))

the following screenshot shows the result:

A Rose

Hi @Barry Bowles ,

I tried the below, would this give me different results?

(Used little different term)

Thank you!

=IF(Created@row <= TODAY(-49), "Past 6 Weeks", 
IF(Created@row <= TODAY(-42), "6 Weeks", 
IF(Created@row <= TODAY(-35), "5 Weeks", 
IF(Created@row <= TODAY(-28), "4 Weeks"))))