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

Mukundraj

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

Mukundraj

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", ""))))

Mukundraj

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", ""))))

Genevieve P.

Hi @Mukundraj

Thanks for posting your solution! I'm glad you were able to figure it out.

Cheers,

Genevieve