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.