Excel’s Date filters are very comprehensive and allow you to extract individual or multiple dates by day, week, month, year, quarter, or year-to-date, plus dates within ranges.

In Excel 2013 Home Menu, select Blank workbook.. Sheet title and custom date. In cell A1, type January 2014.Excel changes the format to Jan-14. Right-click the mouse in that cell and choose Format ...

Let’s see what happens if you add a 2021 date, as shown in Figure D. The function now returns two year balances. It also exposes an error—look closely at the monthly total column.

How to change the date format in Microsoft Excel We're using a spreadsheet that includes dates of hire for employees of a fictitious company, to show different ways to format dates in Excel . 1.