Drop down list of week ending on Friday dates for only current month

[Max168]

How can I create a drop down list of week ending on Friday dates for only current month.
If I use 8/26/22 as my starting reference date, I would like to have a down down list be dynamic and always list the week ending on Friday dates for the month so there’s no need to update once the year changes to 2023 in the upcoming months. IE: 9/2/22, 9/9/22, 9/16/22, 9/23/23 and 9/30/22 will be in the drop down list for Sept

 

[Dave Patton]

The post cited below may help.
The suggestion can be edited if you are only concerned about Fridays.

Return dates in month based on cell value

Hello everyone! I'm trying to include an "interactive" button/slicer option to list out all dates in the current month, based on the day in column D. If I click on D2, K2 to K5 will list out all all Tuesdays based on K1. K1 =today() TIA!

www.mrexcel.com

or

T202208a.xlsm
	A	B	C
1			Friday
2		30-Sep-2022	30-Sep-2022
3	1	Fri, Oct 07, 2022	Fri Oct 07, 22
4	2	Fri, Oct 14, 2022	Fri Oct 14, 22
5	3	Fri, Oct 21, 2022	Fri Oct 21, 22
6	4	Fri, Oct 28, 2022	Fri Oct 28, 22
7	5	Fri, Nov 04, 2022
2e

Cell Formulas
Range	Formula
B3:B7	B3	=WORKDAY.INTL($B$2,A3,"1111011")
C3:C7	C3	=LET(v,WORKDAY.INTL($C2,1,"1111011"),IF(v>EOMONTH($C$2,1),"",v))

 

[Max168]

Thank you Dave I will look at that suggested post. Appreciate the help

 

[Dave Patton]

"Thank you Dave I will look at that suggested post. "

Did you try the suggestion shown in post #2 in this thread?

N.B. You can copy the suggestion to a clean sheet. Click on the icon below the f(x) in the heading and paste into a sheet.

 

[Max168]

Yes I tried your suggestion in post#2 thread and that worked great!! Thx again for the the help Dave!!