Excel Unplugged

Tag Archives: Quarters

Another formula to get quarters from dates

A while back I wrote about multiple ways to get quarters from dates. Even “manual” quarters (starting with any months you like). You can read that post ...

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 ...