Quarter format date

A

Alberto

I'm working with dates and I want to see which quarter the
date is from.
Is there a date format to see quarters?
 
P

Peo Sjoblom

No but you can use formulas, with the date in A1
use this formula for a quarter that starts with the new year

="Q"&INT((MONTH(A1)+2)/3)

and this as an example with a quarter that starts with April 1st

="Q"&INDEX({4;1;2;3},INT((MONTH(A1)+2)/3))
 
J

Jason Morin

Not sure on formatting, but you could use a formula in
another cell:

="Q"&CEILING(MONTH(A1),3)/3

HTH
Jason
Atlanta, GA
 
Top