Quarter Date function

  • Thread starter Thread starter John Weidenfeller
  • Start date Start date
J

John Weidenfeller

Is there a function that you can insert a date and have it tell you the
Quarter it falls into???

=Quarter(2/21/04) would return Q1-2004 or something like that.

Thanks
John
 
You can always make your own function, or you can use something like

=ROUNDUP((MONTH(A1)/3),0)

or

=CHOOSE(ROUNDUP((MONTH(A1)/3),0),"1st quarter","2nd quarter","3rd
quarter","4th quarter")


and use & to join some text (year) to the end of it.
 
If you want financial quarters (1st quarter starts on April 1st) you can use
this

="Q"&INDEX({4;1;2;3},INT((MONTH(A1)+2)/3))&" -
"&IF(INT((MONTH(A1)+2)/3)=1,YEAR(A1)-1,YEAR(A1))
 
Back
Top