Count if Date Column has any dates older than 7 days

GinaN

I know that conditional formatting cannot product formulas so this wont work there. I think i have to insert a new column with a formula, but the formula is giving me trouble.

I have a sheet with a 'date submitted' column. I want to highlight any row that is older than 7 days (from the current day) along with two other conditions being met. If i create a formula column to produce "yes" where the days are over 7 days, i can use conditional formatting for the rest.

The formula is what i am having trouble with since the dates and entries are not fixed, there will be more always being added to the sheet.

Genevieve P.

Hi @GinaN

Try something like this:

=IF([Date Submitted]@row < TODAY(-7), "Yes")

This says, if the date in the Date Submitted column is less than 7 days ago (based on Today's date), then return "Yes".

Cheers,

Genevieve