Clear Data if date in Col F is equal to or less than a certain month and year

[howard]

I have a macro to clear data below

I would like the macro amended to include an input box to enter the month and year so that if the dates in col F (format dd/mm/yyyy) are less than a certain month and year then the data must be cleared, otherwise left intact

If input box contains for Eg Oct 2021, then all dates in Col F prior to Oct 2021 to be cleared except row 1, which contains headers

 Sub Clear Data ()
Dim LR As Long
With Sheets("Data Import")
.UsedRange.ClearContents
  End With
 End Sub

Your assistance in this regard is most appreciated

 

[howard]

Hi Dave & Vcoolio

Many thanks for your help. Both your codes work perfectly

 

[vcoolio]

Your welcome Howard. I'm glad that we were able to assist and thanks for the feed-back.

Cheerio,
vcoolio.