Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
In this video I explain a shortcut with Find and Replace to quickly convert text to dates in Excel. The example is an Excel file that has been exported from Quickbooks Online. However, this technique will work on any file that has dates stored as text.
Download the sample Excel file: https://www.excelcampus.com/tips/text-to-dates-find-replace

I also explain how to determine that the value in the cell is text instead of a date by using either the number format drop-down menu, or the filter drop-down menu. In the filter drop-down menu the dates will NOT be grouped, and instead listed out individually.

Please leave a comment below with any additional tips or techniques you have for converting these dates to a date data type. Thank you!

Additional Resources:

How the Date Calendar System Works in Excel: https://youtu.be/KlCAAQ_tQLA

Convert Text to Dates with Flash Fill: https://youtu.be/ODaEM5HGLKA

How to Add Days to Dates in Excel:
https://youtu.be/py0FWdN255c


#MsExcel #ExcelCampus
00:00 Introduction
01:29 Region Settings
02:04 Text to Columns