Search code examples
google-sheetsanalytics

Yearly quarters formula

In my Google Spreadsheet I need to display the current quarter of the year for my analytics report.

Solution

  • You could try this (add your reference cell with date or a date to the place I've pointed with **)

    =ROUNDUP(MONTH(*reference or date*)/3;0)