Excel Unplugged

Tag Archives: Dates

Learn a foreign language with Excel

Surprisingly, this is not a post about the Translate feature in Excel. Rather we will take an in depth look into Cell Format and a great feature of Excel that allows ...

Formula to get quarters from dates in Excel

We have a column of dates in Excel, and our goal is to get Q1, Q2,… or QTR1, QTR2,… or Quarter 1, Quarter 2,… . I think you get the picture 🙂 First we ...

Sorting months chronologically and not alphabetically in a Power Pivot Pivot Table

Here is our problem. When you create a Pivot Table in Excel that has a date field, you can Group that field by month and the sort will be logical (January, February, ...