Excel is a powerful to, but sometimes has its quirks. When adjusting a spreadsheet from a csv file to a .xlsx file, dates may remain text and you will lose the ability to filter, group and use Pivot Tables with the specialized date tools such as grouping by months, quarters, years, etc. this quick tutorial walks you through how to force Excel to recognize dates as the date format.