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() = Thursday 09 July 2020
2=NOW() = Thursday 09 July 2020 12:28:52
3=A1+(360/4) = 07 Wednesday October 2020
4=A3+(360/4) = 05 Tuesday January 2021
5=A4+(360/4) = 05 Monday April 2021
6=INT((MONTH(A1)+2)/3) = 3
7=INT((MONTH(A3)+2)/3) = 4
8=INT((MONTH(A4)+2)/3) = 1
9=INT((MONTH(A5)+2)/3) = 2
10=ROUNDUP((MONTH(A1)/3),0) = 3

Related Formulas

Return the last day of the current quarter


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