Change Date Format

5 lessons in order

Convert dates to YYYYMMDD format in Excel using TEXT, CONCATENATE, custom number formatting, or VBA for consistent text-based date values.

Display the day of the week from a date in Excel using TEXT, WEEKDAY, CHOOSE functions, or by applying a custom date format easily.

Learn 7 ways to remove the year from dates in Excel, including custom formatting, formulas, Flash Fill, and VBA macros.

Learn how to convert dates to quarter and year in Excel using ROUNDUP, INT, and custom labels for clear, professional quarterly reporting.

Learn how to stop Excel from converting dates to numbers using TEXT, custom formats, apostrophes, and pre-formatting to preserve accuracy.