ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   recurring anniversary dates (https://www.excelbanter.com/excel-discussion-misc-queries/38183-recurring-anniversary-dates.html)

Blackhawk

recurring anniversary dates
 
Trying to highlight recurring anniversary date.
ex:
Hire Date: 02/04/2003
receives new vacation on 02/04/2005.

Highlight that date every year to remind to reset vacation dates. Can this
be done just using the mm/dd, not the year, And have it stay highlighted
until vacation dates reset, then go back to normal?

Using MSExcel 2000

Thank You
Blackhawk


All times are GMT +1. The time now is 12:53 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com