Converting a date in Excel 2002 to a Year/Quarter format

Is there a formula or function that I can use in Excel 2002 to convert a date
to a year/quarter format. For instance if the date said 2/35/2005, I would
like to represent that as 2005Q1 or Q12005, something like that. If someone
has an idea, please share it. Thanks.

Hi,

There isn't a format that does this, but try

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

Regards,

David Jessop

"Jim" wrote:

> Is there a formula or function that I can use in Excel 2002 to convert a date
> to a year/quarter format. For instance if the date said 2/35/2005, I would
> like to represent that as 2005Q1 or Q12005, something like that. If someone
> has an idea, please share it. Thanks.

I tried your syntax below and it worked perfectly David! Thank you very much
for your help and quick response!

"David Jessop" wrote:

> Hi,
>
> There isn't a format that does this, but try
>
> =YEAR(A1)&"Q"&INT((MONTH(A1)+2)/3)
>
> Regards,
>
> David Jessop
>
> "Jim" wrote:
>
> > Is there a formula or function that I can use in Excel 2002 to convert a date
> > to a year/quarter format. For instance if the date said 2/35/2005, I would
> > like to represent that as 2005Q1 or Q12005, something like that. If someone
> > has an idea, please share it. Thanks.