New in last Seven days

Hobo

Column A is the created date

Column B is the status

I the record was created in the last days how do I get column B to say "New"

Thanks in advance 🙏

Paul Newcome

You would use something along the lines of

=IF(DATEONLY([Column A]@row) >= TODAY(-7), "New")