LinkBack URL
About LinkBacks
Hi Im trying to do format some dates I have dates in column F I want to conditionally format to highlight orange if today's date is within 18 months of the dates in column F.
Hi Im trying to do format some dates I have dates in column F I want to conditionally format to highlight orange if today's date is within 18 months of the dates in column F.
Last edited by Carichards07; 04-03-2024 at 04:54 PM. Reason: Uploaded Attachment
I tried to rework this formula I found someone else post to conditionally format dates so the reader knew that the date they entered into the program is getting close to (18 months) which was:
=AND(E8<DATE(YEAR(TODAY())-2,MONTH(TODAY()),DAY(TODAY())),E8<>"")
But mine is slightly different in that I need Column F to highlight orange when Column L (which is set to auto populate to todays current date) is within 18 months of the date in Column F
and to highlight Column F red when Column L is within 12 months of the date of Column F
Have a try for "within 18 months":
=DATE(YEAR($F2),MONTH($F2)-18,DAY($F2))<TODAY()
or
=DATE(YEAR($F2),MONTH($F2)-18,DAY($F2))<$L2
Last edited by rollis13; 04-03-2024 at 05:27 PM.
Difficult is not to know but to share what you know (Han Fei Tzu reworked)
Please Login or Register to view this content.
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks