How to Convert Dates in Excel into Year, Month, or Day Using the Text Formula

How to Convert Dates in Excel into Year, Month, or Day Using the Text Formula

For more Excel tips and tricks be sure to visit me at bradedgar.com.

In this video, I'll show you how to convert dates in Excel into year, month or day using the Text Formula. Using the text formula is very simply and converts the day into text but allows you to easily create and display the name of the month without having any underlying single date associated to the value. This is useful for summarizing data as you can take a date time stamp and turn into a month and then report off of that month, year or day in your pivot table.

Other things I use the text formula for is showing the date as a day (i.e. Tuesday for example) and then using that to update and show my production schedule and what days each completion date falls on.

Using the text formula in conjunction is the perfect tool for converting a date field to again a year, month or day in another column or field on your data set or table.

Other Links and Resources

Convert date to text
exceljet.net/formula/convert-date-to-text

How to convert date to text using Excel TEXT function and no-formula ways
ablebits.com/office-addins-blog/2015/04/08/conv…

Convert a Date to Text in Excel
excelfunctions.net/convert-date-to-text.html

How to convert date to number or text in Excel?
extendoffice.com/documents/excel/2476-excel-con…

How to convert a date into a month name in Excel 2010
dedicatedexcel.com/how-to-convert-a-date-into-a…

Get month name from date
exceljet.net/formula/get-month-name-from-date

How to convert date to weekday name or month name in Excel?
extendoffice.com/documents/excel/821-excel-conv…

Using MONTH and EOMONTH functions in Excel - formula examples
ablebits.com/office-addins-blog/2015/04/22/exce…


Need Formula to Convert Date/Timestamp to Month-Year
mrexcel.com/forum/excel-questions/424192-need-f…

Converting Text Dates to Excel Dates En Masse
k2e.com/tech-update/tips/521-tips-converting-te…

How to convert dates from numeric values to text
sageintelligence.com/tips-and-tricks/excel-tips…

Excel formula: Get day name from date | Exceljet
exceljet.net/formula/get-day-name-from-date

Show dates as days of the week
support.office.com/en-us/article/Show-dates-as-…

WEEKDAY, DAY and other functions to calculate days in Excel
ablebits.com/office-addins-blog/2015/04/16/exce…

How do I get the day name into a cell in Excel?
superuser.com/questions/41883/how-do-i-get-the-…

How to Calculate the Day of the Week in Excel
wikihow.com/Calculate-the-Day-of-the-Week-in-Ex…