Return the current quarter

You can return the current quarter with


 A
1=TODAY() = Wednesday 01 January 2025
2=NOW() = Wednesday 01 January 2025 09:03:02
3=A1+(360/4) = 01 Tuesday April 2025
4=A3+(360/4) = 30 Monday June 2025
5=A4+(360/4) = 28 Sunday September 2025
6=INT((MONTH(A1)+2)/3) = 1
7=INT((MONTH(A3)+2)/3) = 2
8=INT((MONTH(A4)+2)/3) = 2
9=INT((MONTH(A5)+2)/3) = 3
10=ROUNDUP((MONTH(A1)/3), 0) = 1

1 - Displays a date.
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".


Built-in Functions

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


Related Formulas

Return the last day of the current quarter

© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top