dates

Convert Excel Dates to Month Names

               

Need to Subtotal or Group by Month? The TEXT function will take any number or date and convert it to text using a particular custom number format. Try these: =TEXT(A2,”MMMM”) for full month name =TEXT(A2,”MMM”) for 3-letter month abbreviation =TEXT(A2,”DDDD”) for full month name =TEXT(A2,”DDD”) for 3-letter month abbreviation You can use any valid custom(…)

Secret DateDif Function in Excel Calculates Years, Months, Days

               

        Sometimes, you need to show each employee’s age in Years and Months. The cool|secret|sometimes buggy =DATEDIF function does the trick.   This function has not been documented since Excel 2000, so figuring out the third argument is the trick. Enter “Y” to get full years. But, if you enter “M”, you(…)

Learn Excel 2013 – “Sort Pivot Table Text Dates”: Podcast #1679

               

Dates in Text Format in my Pivot Table! We can fix that!

Learn Excel 2013 – “Sort PowerPivot Text Dates”: Podcast #1678

               

Dates in Text, not Date Format? We can sort this out… Bill has a solution!

Don’t Fear The Spreadsheet – “12-13 Becomes 13-Dec?”: Podcast #1561

               

I want my numbers – not a date!

Learn Excel from MrExcel