Thread: Create report for when a date is 3 years old
View Single Post
 
Old 10-26-2022, 02:02 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
Your conditional formatting could be based on something along the lines of:
Code:
=$A2<=DATE(YEAR(TODAY())-3,MONTH(TODAY()),DAY(TODAY()))
where A2 contains your date.
Reply With Quote