Forum

Notifications
Clear all

Conditional format date older than two weeks

2 Posts
2 Users
0 Reactions
209 Views
(@brancc1234gmail-com)
Posts: 2
Active Member
Topic starter
 

I want dates older than two week from today to have cell filled with color.  My formula works but how to I prevent blank cells from being filled as well?

 

=$AA2<TODAY()-14Screenshot-2022-08-04-141138.jpg

 
Posted : 05/08/2022 3:19 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Chuck,

Welcome to our forum!

Try this formula:

=AND($AA2<>"",$AA2<TODAY()-14)

 

Mynda

 
Posted : 05/08/2022 8:14 pm
Share: