Can you format a date cell to produce a quarter reference?

  • Thread starter Thread starter btk
  • Start date Start date
B

btk

I was wondering if anyone new of a way to format a cell
so that when you entered a date (or serial number) that
it would produce a quarter reference. For ex. if I typed
3/3/04 in a cell it would produce Quarter 1, 2004.

Thanking you in advance,

btk
 
If you wanted to change the date into a string "Quarter 1, 2004", you
could use an event macro to do so.

If you just want to display "Quarter 1 2004", then you'd need an
additional cell:

="Quarter " & 1+INT((MONTH(A1)-1)/3) & ", " & YEAR(A1)


If you're in a position to use Pivot tables, you can group dates by
quarter.
 
Back
Top