• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

filter by date


New Member
This question was asked as a challenge in one of your youtube video.
When the data has joining dates and we need to filter the data such that all the joinees in the 3 months of 2018, 2019 and 2020.
Although I am able to filter the data department wise, geography wise, salary wise but not date wise.
I dont know how to do that.
Please help me find a way.
please post a sample sheet (no pics please) with some data .
Which XL version are you using?
joinees in the 3 months of 2018, 2019 and 2020

In the attached, filtered to see only dates from 1/1/2018 to 31/12/2020, which only hides 1 row (row 12).


  • Chandoo56550filter doubt.xlsx
    9.9 KB · Views: 2
i want to ask how to use filter function if we need only those joinee names who joined in the first 3 months of any year
6 ways in the attached.


  • Chandoo56550filter doubt.xlsx
    99.5 KB · Views: 2