date...

[malay_ko]

how will i classify the dates according to its quarter. lets say
01-25-03 (january 25, 2003) is it under 1st quarter, 2nd quarter, 3r
quarter,4th quarter of the year? what date function should i use? o
what do i have to do? pls help me with this. thanx

here is a sample output..

Date(mm-dd-yy) Quarter

01/25/03 1st quarter
6/18/03 2nd quarter
12/20/03 4th quarter
05/23/0

Attachment filename: date.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=53551

 

[Stefan Hägglund [MSFT]]

Hi!

You can use the following formula to calculate the quarter:

=IF(MONTH(A1)<3,"1st Quarter",IF(MONTH(A1)<7,"2nd
Quarter",IF(MONTH(A1)<9,"3rd Quarter","4th Quarter")))

Best regards

Stefan Hägglund
Microsoft

 

[Dave Hawley]

How about a combo of what Frank and Norman offered earlier?

=CHOOSE(ROUNDUP(MONTH(A1)/3,0),"1st Quart","2nd Quart","3rd Quart","4th
Quart")

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[JE McGimpsey]

One way:

=CHOOSE(CEILING(MONTH(A1),3)/3,"1st","2nd","3rd","4th") & " quarter"