Hi,

Am Tue, 2 Feb 2021 11:12:40 -0800 (PST) schrieb Patrick Blanc:

Does anyone know how to highlight dates that are older than 30 days?
For example, today is 2/2/2021.
If I have the date 1/1/2021 in a cell, I want to use conditional formatting to highlight this date because at least 30 days have passed since 1/1/2021. Can anyone help with this?

if your date is in A1 then try in conditional formatting:
=A1<=Today()-30

Regards
Claus B.
--
Windows10
Microsoft 365 for business