Getting info from a date range

[hunytaco]

If I have a list of names in column A and various dates in columns B through E, can I create a formula that pulls names from A if it falls withing a date range of those listed between B and E?

Thanks in advance!

 

[alansidman]

Here is a Macro solution for you. Assumes your dates to search between are in H1 and I1. Highlights Column A with positive results in Red

Option Explicit


Sub FindName()
    Dim i As Long
    Dim lr As Long
    Dim mMax As Date
    Dim mMin As Date
    Dim rng As Range, c As Range
    lr = Range("A" & Rows.Count).End(xlUp).Row
    For i = 1 To lr
        Set rng = Range("B" & i & ":E" & i)
        mMin = Range("H1")
        mMax = Range("I1")
        For Each c In rng
            If c > mMin And c < mMax Then
                Range("A" & i).Interior.ColorIndex = 3
            End If
        Next c
    Next i
End Sub

 

[hunytaco]

Here is a Macro solution for you. Assumes your dates to search between are in H1 and I1. Highlights Column A with positive results in Red

Option Explicit


Sub FindName()
    Dim i As Long
    Dim lr As Long
    Dim mMax As Date
    Dim mMin As Date
    Dim rng As Range, c As Range
    lr = Range("A" & Rows.Count).End(xlUp).Row
    For i = 1 To lr
        Set rng = Range("B" & i & ":E" & i)
        mMin = Range("H1")
        mMax = Range("I1")
        For Each c In rng
            If c > mMin And c < mMax Then
                Range("A" & i).Interior.ColorIndex = 3
            End If
        Next c
    Next i
End Sub

Thanks for this! I'll try this out now. Any chance this could be translated to a formula?