Sh8dyDan
New Member
- Joined
- Dec 20, 2023
- Messages
- 25
- Office Version
- 365
- Platform
- Windows
I'm building a timesheet for myself. I want to add holiday icons at the top of the timesheet for the holidays that fall within the timesheet's date range. I have tabs named "Timesheet" and "Holidays". I have a named range for holidays "HolidaysRotatingShift". It is a work in progress and I have been doing alright. I just can't figure out what I need to do to have Excel look at the date column on the tab Timesheet, compare those dates in the defined name range on the Holidays tab, and then in cell P3 on the Timesheet tab display all the icon of the holidays within the Date column.
Thank you in advance,
Dan N.
Thank you in advance,
Dan N.