Select Slicer Based On Day

[MrPatPat]

Hi all,

I have 5 slices for 5 weekdays (Mon, Tue, Wed, Thur, Fri) and I would like a button to trigger a slicer based on the day of the week.

Open to any suggestions as well.

I have an employee list with 5 columns (Mon, Tue, Wed, Thur, Fri) that either have "yes" or "no" value and just need a button to show who's not in on the current day the spreadsheet is open.

I can add simple formulas like "=TEXT(TODAY(),"ddd")" to return the current day but just not sure how to connect to a macro to fire off a slicer relating to the current day.

The button in green below says "Who's Here Today?" but would just to Who's Not Here Today, as you can see, for Thursday it would show that one entry as it has "No".

 

[GraH]

Why not work around the issue?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Real variable	7
2	test variable	2
3
4		level	F Name	L Name	MON	TUE	WED	THU	FRI	Fire Warden	Fire Warden Level	Here Today?
5					Yes	Yes	Yes	Yes	Yes			Yes
6					Yes	Yes	Yes	Yes	Yes			Yes
7					Yes	Yes	Yes	No	Yes			Yes
8					Yes	No	Yes	Yes	Yes			No
9					Yes	No	No	Yes	Yes			No
Sheet1

Cell Formulas
Range	Formula
B1	B1	=WEEKDAY(TODAY(),2)
L5:L9	L5	=INDEX(Table1[@[MON]:[FRI]],$B$2)

Only 1 slicer needed on the extra column. (which can be hidden).