Select Filter between two dates

[Nick70]

Hi,

I would like a code so that the filter selects dates between January 2024 and December 2024.
Data is in Sheet1 in range(A5:Z100)
Date filter is on column C

Which code can do that?

Thanks,
Nic

 

[Joe4]

Using the new FILTER function, it would look like:

=FILTER(A5:Z100,YEAR(C5:C100)=2024)

 

[Nick70]

Not sure I understand this filter formula but I was looking for a VBA code to select filter for me automatically (so I do not have to do selection manually).

Txs,
Nic

 

[Joe4]

Excel 365 has a new FILTER function which makes this very easy (though it filters to a separate range). See: FILTER function - Microsoft Support.

Are you saying that you just want to apply the filters to the current data and "filter in place"?
Regarding your range (rows and columns), what can change and what must stay the same?

 

[Nick70]

Ok thanks.
Great formula but was looking for VBA code.

In answer to your questions:

Are you saying that you just want to apply the filters to the current data and "filter in place"? - YES
Regarding your range (rows and columns), what can change and what must stay the same? - Rows can change

Txs,
N.

 

[Joe4]

OK, I think this should do what you want:

Sub MyFilterCode()

    Dim lr As Long
    Dim rng As Range
   
'   Find last row in column C with data
    lr = Cells(Rows.Count, "C").End(xlUp).Row
   
'   Set range to filter
    Set rng = Range("A4:Z" & lr)
   
'   Set filter
    rng.AutoFilter
    rng.AutoFilter Field:=3, Criteria1:=">=1/1/2024", Operator:=xlAnd, Criteria2:="<=12/31/2024"
       
End Sub

 

[Nick70]

Great thanks!
Nic

 

[Joe4]

You are welcome.
Glad I was able to help!