How to automatically assign a Symbol when comparing two date columns?

Roberto Sanchez

This is what I got.

=IF([Launch Date]@row >= [Estimated Delivery Date]@row, "Green", IF([Launch Date]@row < [Estimated Delivery Date]@row, "Red"))

However, I want "Yellow" to be assigned when the [Estimated Delivery Date] is less than 30 days from the [Launch Date].

Appreciate the insight.

Bassam Khalil

Hi @Roberto Sanchez

Hope you are fine, please try the following formula:

=IF(OR([Estimated Delivery Date]@row = "", [Launch Date]@row = ""), "",
IF([Launch Date]@row - [Estimated Delivery Date]@row >= 30, "Green",
IF([Launch Date]@row < [Estimated Delivery Date]@row, "Red",
IF([Launch Date]@row - [Estimated Delivery Date]@row < 30, "Yellow"))))

the following screenshot shows the result:

Roberto Sanchez

Thank you so much. Worked as intended on my end.

Bassam Khalil

@Roberto Sanchez

Excellent, I will be happy to help you any time. Please help the Community by marking it as an accepted answers