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(…)
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(…)
Dates in Text Format in my Pivot Table! We can fix that!
Dates in Text, not Date Format? We can sort this out… Bill has a solution!
I want my numbers – not a date!