Date over 30 days = "text" formula help

Nathan Horn

I have a column where a date will be entered. Based on that date in another column, I want to state "Pending" if the date is over 30 days past the original entry date.

=IF([DeliveryDate]@row > TODAY(+30), "Pending")

I'm not getting errors with this, however, the text "Pending" is not displaying when the DeliveryDate is over the 30 day mark.

Any direction is appreciated.

Bassam Khalil

Hi @Nathan Horn

Hope you are fine, please try the following formula and convert it to a column formula.

=IF(TODAY(-30) > [Delivery Date]@row, "Pending")

Bassam Khalil

Hi @Nathan Horn

Hope you are fine, please try the following formula and convert it to a column formula.

=IF(TODAY(-30) > [Delivery Date]@row, "Pending")

Nathan Horn

Bassam,

This works perfectly. Thank you for your assistant!

Bassam Khalil

@Nathan Horn

you are more than welcome

don't forget to vote for me :)