# Past Due, 1 to 30 days , 31 to 60 days & 61 to 90 days

Options
edited 01/24/22

Hi Team,

I have a "Planned start date" column , I need data for Past Due, 1 to 30 days , 31 to 60 days & 61 to 90 days in once cell, could you help.

=IF(TODAY() > [Planned Start Date]@row, "Past Due", IF([Planned Start Date]@row <= TODAY(1-30), "Start < 30 Days"))

Out comes : "Past Due" "Start < 30 Days" "Start between 31 to 60 Days" & "Start between 61 to 90 Days"

Regards,

Mukund

Options

I somehow found the formula

=IF([Planned Start Date]@row < TODAY(), "Past Due", IF([Planned Start Date]@row <= TODAY(30), "Start < 30 Days", IF([Planned Start Date]@row <= TODAY(60), "Start between 31 to 60 Days", IF([Planned Start Date]@row <= TODAY(90), "Start between 61 to 90 Days", ""))))

Options

I somehow found the formula

=IF([Planned Start Date]@row < TODAY(), "Past Due", IF([Planned Start Date]@row <= TODAY(30), "Start < 30 Days", IF([Planned Start Date]@row <= TODAY(60), "Start between 31 to 60 Days", IF([Planned Start Date]@row <= TODAY(90), "Start between 61 to 90 Days", ""))))