Calculate a quarter
Get incorrect results:
2/1/2008 = 2Q08
6/1/2008 = 3Q08
--
Biff
Microsoft Excel MVP
"Fred Smith" wrote in message
...
=TEXT(MONTH(A1)/4+1,"0")&"Q"&TEXT(MOD(YEAR(A1),100),"00")
Regards,
Fred.
"JPS" wrote in message
...
I have a large spreadsheet that is a five-year forecast. In one column is
a
date, I need to know a way to calculate the quarter, in XQYY format, the
event is forecasted to happen. Where X is the quarter from the table
below, Q
is a set value and XX is the forecast year.
Date Range Quarter
January - March 1
April - June 2
July - September 3
October - December 4
For example, March 2009, would be 1Q09.
Thanks,
--
JPS
|