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

Max168

New Member
Joined
Aug 29, 2022
Messages
3
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
The post cited below may help.
The suggestion can be edited if you are only concerned about Fridays.

or
Cell Formulas
RangeFormula
B3:B7B3=WORKDAY.INTL($B$2,A3,"1111011")
C3:C7C3=LET(v,WORKDAY.INTL($C2,1,"1111011"),IF(v>EOMONTH($C$2,1),"",v))
 
Upvote 0
Solution
Thank you Dave I will look at that suggested post. Appreciate the help😉
 
Upvote 0
"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.
 
Upvote 0
Yes I tried your suggestion in post#2 thread and that worked great!! Thx again for the the help Dave!!
 
Upvote 0

Forum statistics

Threads
1,213,557
Messages
6,114,291
Members
448,564
Latest member
ED38

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top