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 http://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 https://exceljet.net/formula/convert-date-to-text How to convert date to text using Excel TEXT function and no-formula ways https://www.ablebits.com/office-addins-blog/2015/04/08/convert-date-text-excel/ Convert a Date to Text in Excel http://www.excelfunctions.net/convert-date-to-text.html How to convert date to number or text in Excel? https://www.extendoffice.com/documents/excel/2476-excel-convert-date-to-text-or-number.html How to convert a date into a month name in Excel 2010 http://dedicatedexcel.com/how-to-convert-a-date-into-a-month-name-in-excel-2010/ Get month name from date https://exceljet.net/formula/get-month-name-from-date How to convert date to weekday name or month name in Excel? https://www.extendoffice.com/documents/excel/821-excel-convert-date-to-weekday-month-name.html Using MONTH and EOMONTH functions in Excel - formula examples https://www.ablebits.com/office-addins-blog/2015/04/22/excel-month-eomonth-functions/ Need Formula to Convert Date/Timestamp to Month-Year http://www.mrexcel.com/forum/excel-questions/424192-need-formula-convert-date-timestamp-month-year.html Converting Text Dates to Excel Dates En Masse http://www.k2e.com/tech-update/tips/521-tips-converting-text-dates-to-excel-dates-en-mase How to convert dates from numeric values to text https://www.sageintelligence.com/tips-and-tricks/excel-tips-tricks/2013/09/convert-dates-numeric-values-text/ Excel formula: Get day name from date | Exceljet https://exceljet.net/formula/get-day-name-from-date Show dates as days of the week https://support.office.com/en-us/article/Show-dates-as-days-of-the-week-14f02f1d-8e3d-45a5-bdf8-3d962bf15327 WEEKDAY, DAY and other functions to calculate days in Excel https://www.ablebits.com/office-addins-blog/2015/04/16/excel-weekday-day-functions/ How do I get the day name into a cell in Excel? http://superuser.com/questions/41883/how-do-i-get-the-day-name-into-a-cell-in-excel How to Calculate the Day of the Week in Excel http://www.wikihow.com/Calculate-the-Day-of-the-Week-in-Excel