Wednesday, January 16, 2013

How to Determine Quarter in Excel 2003


1. Open Microsoft Excel.
2. Type a date in cell A1. For example, type '4/11/2010' in cell A1.
3. Type the following formula in cell A2, '=CHOOSE(MONTH(A1),'Q1','Q1','Q1','Q2','Q2','Q2','Q3','Q3','Q3','Q4','Q4','Q4') '-' RIGHT(YEAR(A1),2).' Cell A2 now displays 'Q2-10.'

Blogger news