Display Holiday Icons on Timesheet

[Sh8dyDan]

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.

 

[Eric W]

Try:

Book1
	D	E	F									O	P
3	12 Hour Rotating Shift Timesheet												🎄🎁🎉
4
5	Date
6	12/18/2023
7	12/19/2023
8	12/20/2023
9	12/21/2023
10	12/22/2023
11	12/23/2023
12	12/24/2023
13	12/25/2023
14	12/26/2023
15	12/27/2023
16	12/28/2023
17	12/29/2023
18	12/30/2023
19	12/31/2023
20	1/1/2024
Sheet2

Cell Formulas
Range	Formula
P3	P3	=CONCAT(FILTER(Holidays!J6:J16,(Holidays!L6:L16>=MIN(D6:D25))*(Holidays!L6:L16<=MAX(D6:D25))))

 

[Sh8dyDan]

Try:

Book1
	D	E	F									O	P
3	12 Hour Rotating Shift Timesheet												🎄🎁🎉
4
5	Date
6	12/18/2023
7	12/19/2023
8	12/20/2023
9	12/21/2023
10	12/22/2023
11	12/23/2023
12	12/24/2023
13	12/25/2023
14	12/26/2023
15	12/27/2023
16	12/28/2023
17	12/29/2023
18	12/30/2023
19	12/31/2023
20	1/1/2024
Sheet2

Cell Formulas
Range	Formula
P3	P3	=CONCAT(FILTER(Holidays!J6:J16,(Holidays!L6:L16>=MIN(D6:D25))*(Holidays!L6:L16<=MAX(D6:D25))))

Thank you, worked perfectly.

 

[Churchy LaFemme]

Hey - pretty cool question. This would never have occurred to me. I think some of my workbooks are going to be more fun soon....