Hello friends,

Please refer attached sample file.

I have dates in column A that do not appear in the date format , eg 1.2013. 2.2013, 3.2013 etc

I have like to use a formula in another column B which will give me -

Q1 2013(which means quarter 1) for all dates that are 1.2013, 2.2013, 3.2013
Q2 2013 (which means quarter 2) for all dates that are 4.2013, 5.2013,6.2013
Q3 2013 (which means quarter 3) for all dates that are 7.2013, 8.2013,9.2013
Q4 2013 (which means quarter 4) for all dates that are 10.2013, 11.2013,12.2013

Thanks