Quarter Date function

[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

 

[Dave R.]

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.

 

[Frank Kabel]

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

or
="Q-" & ROUNDUP((MONTH(A1)/3),0) & Year(A1)

 

[Peo Sjoblom]

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))