Create report for when a date is 3 years old

		Microsoft Office Forums > Microsoft Excel > Excel
Create report for when a date is 3 years old

10-26-2022, 02:02 AM

p45cal

Windows 10 Create report for when a date is 3 years old

Office 2019

Expert

Join Date: Apr 2014

Posts: 948

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.

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
create a report	karkey	Word VBA	0	01-03-2021 08:51 PM
Formula indicating employees entitled to a salary increase every three years from date of appointmen	Marcia	Excel	4	08-13-2018 03:33 PM
Nested If Statements in Formula Field to Produce the Diffrnc in Years Between Today's & Entered Date	mshu31	Word	1	02-09-2017 02:04 PM
Date range mysteriously adding 4 years	akatz85	Excel	7	03-25-2014 12:36 PM
Using Field Codes to Calculate 5 years from a Date	vandy	Word	1	09-23-2009 11:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:36 PM.