Finding specific days of a week within date range

[reporting_95]

Hi,

I have a number of date ranges and what I would like to do is find specific days of the week within the range. For example, I have the date range 6/1/19-8/1/19 and I'd like to know the dates for the Mondays and Wednesdays within that date range. I'm looking to associate the name of the day and date to a list of events that meet on specific days of the week, but only supply the date range. Once I have the names of the specific days I'm looking for, I would be able to quickly filter by that day and see what event is taking place on the day and date. I tried the =Networkdays.intl formula but that gives me a count as opposed to the actual day and date. Is there such a formula that can help me accomplish this?

Please kindly advise.

Thanks!

 

[JustynaMK]

Hi,

Assuming that your date range is specified in cells A1 & A2, e.g.
A1 = 01/06/2019
A2 = 01/07/2019

You can use the following Array formula (Ctrl+Shift+Enter) in cell C1:

=IFERROR(SUMPRODUCT(SMALL(IF(WEEKDAY($A$1+ROW(INDEX(A:A,1):INDEX(A:A,$A$2-$A$1+1))-1,2)=[COLOR=#ff0000]{1,3}[/COLOR],$A$1+ROW(INDEX(A:A,1):INDEX(A:A,$A$2-$A$1+1))-1),ROW())),"")

This should show you the first Monday/Wednesday in this date range. Afterwards you need to simply drag the formula down a few cells to see the remaining dates.
I have highlighted the part which is responsible for selecting Monday (1) and Wednesday (3).

I hope it helps.

 

[reporting_95]

My apologies for the late response. Looks like this works. Thanks again!!

 

[JustynaMK]

No worries! Glad it helped.