Highlight an anniversary date for the whole calendar year

Copper Contributor

Below is a section of the workbook that has earned bonus vacation hours based on anniversary date that I will be sharing with a group of people that need to see current available bonus hours for each persons calendar year based on the date they were hired.

 

In this example, I need A6 thru E6 to stay highlighted 11/12/2022 thru 11/11/2023 and A7 thru E7 to stay highlighted 11/12/2023 thru 11/11/2024 when those dates roll around, next year it will roll over to 2023 and 2024 and so on.

All the formulas I've found are based on today's date not from YEAR / MONTH / DAY to YEAR / MONTH / DAY I know there is a simple formula and I'm over thinking it. 

 

Thanks so much for any help offered. :smile:

A                                B                                C                              D                              E

NAME                        HIRE DATE                 ANN DATE                YEAR                       AVAIL BONUS HRS

DOE, JOHN11/18/201811/18/2022202240
DOE, JOHN11/18/201811/18/202320230
DOE, JANE4/5/20164/5/202220220
DOE, JANE4/5/20164/5/202320230

 

0 Replies