Flag a date

12/31/20
Answered - Pending Review

How do I say

=if the date is 30 days in the past = flag

Answers

  • Leibel SLeibel S ✭✭✭✭

    See below. Change column name to match your Date column name.

    =IF((TODAY() - [Date]@row) > 30, 1, 0)

Sign In or Register to comment.