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.

Attachment filename: date.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=53551
--
Message posted from http://www.ExcelForum.com

VBA. Assuming the date is in variable myDate

month(date)\4+1

Worksheet

=INT(MONTH(A1)/4)+1


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"malay_ko " wrote in message
...
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, 3rd
quarter,4th quarter of the year? what date function should i use? or
what do i have to do? pls help me with this. thanx

here is a sample output..

Attachment filename: date.xls
Download attachment:
http://www.excelforum.com/attachment.php?postid=535514
---
Message posted from http://www.ExcelForum.com/