Quarter format date

[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?

 

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

 

[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