Calendar Quarter From a Date (Formula)
How It Works
- What it does: Turns a date into its calendar quarter.
- What you get: A short label – a March date shows Q1, an August date shows Q3.
- If a value is missing: If Date is blank, the column shows a blank or an error instead of a quarter.
Common Use Cases
- Quarterly sales or pipeline grouping
- Quarterly business reviews
- Seasonal planning views
- Quarter-based filtering
Details
- Formula Type: Calculated Column
- Formula Category: Dates & Time
Required Columns
| Display name | Column type |
|---|---|
| Date | Date and Time |
| Calendar Quarter From a Date | Calculated |
Prerequisites
- Create the column the formula reads: Date
- Add or edit a few items so there is data for the formula to work with
How to Apply the Formula
- Add a column, choose More…, then select Calculated (calculation based on other columns)
- Set the data type returned from this formula to Single line of text
- Paste the formula below into the Formula box
- Click OK to create the column
Formula
="Q"&ROUNDUP(MONTH([Date])/3,0)Variations
- Quarter on its own:
="Q"&ROUNDUP(MONTH([Date])/3,0) - Quarter and year label:
="Q"&ROUNDUP(MONTH([Date])/3,0)&" "&YEAR([Date]) - Year first so it sorts correctly:
=YEAR([Date])&" Q"&ROUNDUP(MONTH([Date])/3,0) - Fiscal quarters starting in October:
="Q"&ROUNDUP((MOD(MONTH([Date])+2,12)+1)/3,0)
Common Questions About Calendar Quarter From a Date Formula
What does this formula do?
Q1-Q4 from a date. It lives in a calculated column, so SharePoint fills the value in automatically for every item.
Which columns do I need to set this up?
You need: Date (Date and Time). The formula reads these to produce its result.
Can I change the formula for my own columns?
Yes. Swap the column names in brackets for your own, and adjust any numbers or text.
If LookBook 365 is code-free and out-of-the-box, why does this example use a formula?
A SharePoint formula is native, declarative configuration, not custom development. It only works with the item’s own fields and simple logic – it cannot run scripts, reach external services, or change other data, and nothing is deployed to your tenant. It keeps working through Microsoft updates. If you would rather not set this up yourself, this is exactly the kind of thing I configure for clients.
How do I show the quarter and the year together, like Q3 2026?
Add the year on the end: ="Q"&ROUNDUP(MONTH([Date])/3,0)&" "&YEAR([Date]). If you plan to sort on it, put the year first instead so 2026 Q1 lands before 2026 Q2.
Can I use my fiscal quarters instead of calendar quarters?
Yes. Shift the month before dividing. For a fiscal year that starts in October, ="Q"&ROUNDUP((MOD(MONTH([Date])+2,12)+1)/3,0) makes October to December Q1.
