Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
LIVE

Making and If Statement using a date

Copper Contributor

I would like cell to highlight green if the cell next it is older than last week or a specific date.  

 

1 Reply

@leannrobinsonelevateK 

A conditional formatting formula like below will check is the week number of a date entered in A1 is less than the current week number minus 1 or on a particular date. In the formula I hard-coded September 1, 2022, but you could replace that by a reference to a cell that contains "a specific date".

=OR(ISOWEEKNUM(A1)<ISOWEEKNUM(TODAY())-1,DATE(2022,9,1))

 

In Excel for the web, it looks like this:

Screenshot 2022-09-05 at 06.13.39.png

Screenshot 2022-09-05 at 06.13.12.png