If you have a range of date, and if you want to filter the data as per year or month, you can do it by using the Format Cells and Auto filter option in Microsoft Excel.
In this article, we will learn using Format Cells to format the date in Month or Year as per the filtration requirement.
Let’s take an example to understand how we can filter the data by the date.
We have data in range A1: C18. Column A contains date, column B contains customer name and column C contains Revenue amount.
If we want to put the filter as per the Month and year, we need to follow below given steps:-
Now list is ready to filter the data according Month and year criteria.
To insert the Auto Filter, select the cell A1 and press the key Ctrl+Shift+L. And filter the data according to the month and year.
This is the way we can put the filter by the date field in Microsoft Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.