Filter for Entire Month of 2024

[daveyc18]

So I have a bunch of dates in September 2024 in column A; is there a way to filter only September THIS YEAR and ignore the other months

 

[alansidman]

=FILTER(A2:A76,MONTH(A2:A76)=9*(YEAR(A2:A76)=2024))

This formula assumes 75 rows of date in Column A and filters for September and year 2024

 

[daveyc18]

=FILTER(A2:A76,MONTH(A2:A76)=9*(YEAR(A2:A76)=2024))

This formula assumes 75 rows of date in Column A and filters for September and year 2024

would you know how to do this via VBA? eg advanced filter, as I want to open the file, filter for sept 2024 only

 

[alansidman]

Need to be patient and wait for a VBA expert. Not my forte. For the future, you should specify your specific needs (ie. VBA) in your initial post or the title. Crystal Balls are in short supply these days.

 

[Skyybot]

So I have a bunch of dates in September 2024 in column A

Sounds like there are only already dates of the month September of the year 2024. How can you filter out months, or years, that aren't there? And which are you trying to filter? Months or Years, or Days of a Month? Do you mean that you have a bunch of general dates, and you want to filter September 2024 out of all of the other possible months of any other year?