How do I filter between two dates in YYYYMM format?

[Knockoutpie]

I'm really at a loss here as I cannot start my project without first completing this step..

In column 'A' I have dates in YYYYMM format and i'm trying to filter between ranges from YYYY-1/MM to YYYY/MM-1 (where YYYY/MM = current year/current month)

Between current year minus 1 year and then current year and month minus 1 month.

Any help would be greatly appreciated.

YYYYMM
201805
201805
201706
201805
201902
201805
201805
201805
201805
201805
201805
201805
201805
201805
201805
201902
201805
201805
201805
201705
201805
201805
201804

<tbody>
</tbody>

 

[dmt32]

Hi,
if want VBA solution following untested but see if does what you want

Sub FilterDates()


        Dim StartDate As Long, EndDate As Long
    
        StartDate = DateSerial(Year(Date) - 1, 1, 1)
'0 - represents the last day of the previous month
        EndDate = DateSerial(Year(Date), Month(Date), 0)
        
'apply filter
        ThisWorkbook.Worksheets("Sheet1").UsedRange.AutoFilter Field:=1, _
                                                Criteria1:=">=" & StartDate, _
                                                Operator:=xlAnd, _
                                                Criteria2:="<=" & EndDate
End Sub

Dave