Convert To Date

4 lessons in order

Learn how to convert numbers to date format YYYYMMDD in Excel using formulas, Text to Columns, and custom number formatting techniques.

Learn how to convert timestamps to dates in Excel using TEXT functions, formulas for Unix timestamps, base date adjustments, or VBA methods.

Learn how to convert 8-digit numbers to dates in Excel using formulas, Flash Fill, Power Query, Text to Columns, or VBA macros.

Convert text to proper date and time in Excel using VALUE, DATEVALUE, TIMEVALUE, Text to Columns, Paste Special, and quick formatting fixes.