Find dates within a range that match weekdays

[VBGeek]

Hi all, I have a spreadsheet as shown below. I'm trying to write formulas to display the weekday date where the day number falls within the date range StartDate & EndDate.

For example:
in row one the range is 02NOV21-06NOV21 and has 2(Tue), 4(Thu) and 6(Sat) so what I need to show is 02NOV21 (Tue), 04NOV21 (Thu) & 06NOV212 (Sat).
The same applies to each row.
Any Excel Gurus with advice out there would be much appreciated

StartDate	EndDate	Mon	Tue	Wed	Thu	Fri	Sat	Sun
02NOV21	06NOV21		2​		4		6
09NOV21	14DEC21		2		4		6
17DEC21	31DEC21		2			5
20DEC21	03JAN22	1
04JAN22	25FEB22		2			5

 

[etaf]

where do you need to show that , and in what format
Not 100% sure i follow
is the table you show - the data you have already got populated and looking for the dates

What do you want to show for the last row
4-jan-22 to 25-feb-22
is that ALL the tuesday dates and all the Friday dates listed in the range?

And again the 2nd to last row, only has a monday flagged with a 1 - so is that list every monday between 20-dec-21 to 3rd jan-22

maybe examples of results expected

can you use XL2BB to post a spreadsheet sample
or on a share like onedrive, dropbox, googlesheet

 

[VBGeek]

Hi and many thanks for the response. I actually figured out how to do it in Python so please close this thread.

 

[smozgur]

If you can post your solution, then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution as we don't use "mark as solution" as "closing a thread".