Create text from Date

[PARans]

Hi,

I have a column of dates and I want to insert a column next to it which displays the quarter for the date in the following format:

05/24/08 2Q2008

In the quarter column (which is formatted as General) I have entered the following formula but the result is 2Q1905

=TEXT(ROUNDUP(MONTH(A2)/3,0),"0")&"Q"&TEXT(YEAR(A2),"yyyy")

How do I fix?

Thanks,
Paula

 

[facethegod]

Try taking out YEAR(A2)..

=TEXT(ROUNDUP(MONTH(A2)/3,0),"0")&"Q"&TEXT(A2,"yyyy")

 

[PARans]

Beautiful! Thank you for your help!

Paula