Creating a list of specific dates from a weekly date range

[killeen]

Hello,

So I have a large spreadsheet where each row represents a date range for a specific event that happens on specific days of the week. Here are some examples:

How do I pull out each applicable date from each date range using Excel or other functionality? Any insight to give me some ideas would be greatly appreciated. Thanks in advance.

 

[Anthony47]

The request is too vague, so I assumed you would like to select one line of the table and get in a columns of your sheet the list of dates for that event.
Also I request that your "Days" are expressed in a more suitable form, ie a list of weekdays such as
1 for Monday
2 for Tuesday
1,2,3,5 for Monday, Tuesday, Wednesday, Friday

Let's suppose this is in column G

Now rightclick on the tab with the name of the worksheet with the table; select Display Code; this will open the editor of the macro at "the right position"
Copy the following code and paste it into the empty right frame of the editor:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim FreeCol As Long, RuleC As Long, CInd As Long
'
FreeCol = 10            '<<< 10=J
RuleC = 7               '<<< 7=G
With Target.Range("A1")
    If .Column = 2 Then
        If IsDate(.Value) Then
            Columns(FreeCol).ClearContents
            mysplit = Split(Replace(.Offset(0, RuleC - 2).Value, " ", "") & ",9,", ",", , vbTextCompare)
            For i = .Value To .Offset(0, 1).Value
                If Not IsError(Application.Match(Weekday(i, vbMonday) & "", mysplit, False)) Then
                    CInd = CInd + 1
                    Cells(CInd, FreeCol).Value = CDate(i)
                End If
            Next i
        End If
    End If
End With
End Sub

Edit the two lines marked <<<:
FreeCol is the column where the result will be written; 10 means J
RuleC is the column where the "event days" are written as sequence of numbers as sayd before; 7 means G

Now return to the worksheet and select a date in column B: the dates with that event will be listed in column J (if FreeCol=10), as shown in the attached image
(the weekday in column K is obtained using the formula shown in column L)

Hope this give you some useful insights...