VBA If statement

[Pinaceous]

Dear All,

I have two dates, where I'd like a message box to pop, if the dates are between this criteria.

    sDate1 = #10/1/2019#
    sDate2 = #9/30/2020#

How would I create the following?

 If date is between sDate1 & sDate2 Then
                                        
             MsgBox " Dates Within Range" 
   
End If

Thank you!
pinaceous

 

[DanteAmor]

That msgbox no!
It is the msgbox that says "valid dates", I put it in post #17.
I didn't want to put the whole macro, but to avoid confusion, here it is:

Sub test1()
  Dim wCount As Variant, c As Range
  Dim sDate1 As Date, sDate2 As Date
  sDate1 = #10/1/2019#
  sDate2 = #9/30/2020#
  wCount = WorksheetFunction.Count(Range("B6:B66"))
  If wCount = 0 Then
    MsgBox "NO Dates Listed"
  Else
    For Each c In Range("B6:B66")
      If c <> "" Then
        If IsDate(c) Then
          If sDate1 <= c And c <= sDate2 Then
            MsgBox "Valid Dates Listed"
            Exit For
          Else
          
          End If
        End If
      End If
    Next
  End If
End Sub