Filtering past and future months

[Navi]

Hi Team,

Need a help in excel macro.

I have a set of two to three years dates in a column (Mm/dd/yy format)

i need to filter the last month and the next six months date... how do I do that.

Please help.

Thanks,
Navi

 

[vletm]

Navi
It would be better to upload a sample file to get replies...
if You won't search Your needed answer from this forum.

 

[Navi]

Thanks. I have attached a file where we have date from 2018 till 2022.

my requirement is that, each month when i work in this file i need to filter from 2018 to next future 6 months.

eg: am working in October. i need to select from 2018 date till April 2020. That is 2018 till October 2019 is current + next 6 months.

 

[vletm]

Navi
Your:
a) filter the last month and the next six months date
b) filter from 2018 to next future 6 months.
c) am working in October. i need to select from 2018 date till April 2020. ...
Could You give ONCE from which date to which date?
and
what would be those dates 45 days later?
If You cannot give dates - then even give Months and Years (eg Oct 2018 - Apr 2019).

Okay ... no answer not yet.
Here is a sample.
Select Cell A1 to get one of Your needed version of Filtering.
You can modify periods as You want.

 

[Navi]

Navi
Your:
a) filter the last month and the next six months date
b) filter from 2018 to next future 6 months.
c) am working in October. i need to select from 2018 date till April 2020. ...
Could You give ONCE from which date to which date?
and
what would be those dates 45 days later?
If You cannot give dates - then even give Months and Years (eg Oct 2018 - Apr 2019).

Okay ... no answer not yet.
Here is a sample.
Select Cell A1 to get one of Your needed version of Filtering.
You can modify periods as You want.

HI This is working fine.. thanks a lot. i will edit the period alone. Very helpful

 

[Navi]

Hi [U]vletm[/U],

Need one more help. How can i embed the macro in different files n run. because if i use the same code you provided it runs automatically.. i need to run with a click

 

[vletm]

You can copy that code to any code-sheet ... and ... click cell-A1.

 

[Navi]

hi i want to run when click of a button

 

[vletm]

hi hi
1) ReName that macro
2) Create a button
3) Attach that named macro to that created button
4) Click that button