Return the current quarter

You can return the current quarter with
Cell "A1" displays a date.
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

	A
1	=TODAY() = Sunday 01 May 2022
2	=NOW() = Sunday 01 May 2022 18:37:54
3	=A1+(360/4) = 30 Saturday July 2022
4	=A3+(360/4) = 28 Friday October 2022
5	=A4+(360/4) = 26 Thursday January 2023
6	=INT((MONTH(A1)+2)/3) = 2
7	=INT((MONTH(A3)+2)/3) = 3
8	=INT((MONTH(A4)+2)/3) = 4
9	=INT((MONTH(A5)+2)/3) = 1
10	=ROUNDUP((MONTH(A1)/3),0) = 2

Built-in Functions

NOW - The serial number of the current system date and time.
TODAY - The serial number representing today's date.

Related Formulas

Return the last day of the current quarter