Within 30 Days From Today

A Rose

Hi,

I have 2 columns,

1. Todays Date, Formula: =Today
2. Date Submitted,

I need a formula to tell me if Date Submitted is more than 30 days ago, if yes say "Overdue"

Any ideas?

Thank you!😀

Heather Duff

Hi @A Rose ,

Try this:

=if([date submitted]@row <TODAY(-30), "Overdue","")

Let me know if it works for you!

Best,

Heather