What is Filtering date in brief.
Answers
Answered by
5
Answer:
On the Data tab, in the Sort & Filter group, click Filter.
- Arrows in the column headers appear.
- Click the arrow next to Date. ...
- Click OK. ...
- Click the arrow next to Date. ...
- Result. ...
- Note: this date filter and many other date filters depend on today's date.
Answered by
3
Filtering reports by a specific date range is a popular application of filters. You could set your report to filter by a specific range such as 12/1/2013 through 12/31/2013 (which would give you data between those dates). This means whenever you re-run your data, it would give you the latest week or month of data.
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.
• Hope it helps uh
• Mark as brainlist
Similar questions