One way

=CHOOSE(INDEX({1;2;3;4},INT((MONTH(A1)+2)/3)),IF(DAY(DATE(YEAR(A1),2,29))=29,91,90),91,92,92 )

will take care of leap years as well

if only for 2007


=CHOOSE(INDEX({1;2;3;4},INT((MONTH(A1)+2)/3)),90,91,92,92)



--

Regards,

Peo Sjoblom

"Mahesh" wrote in message
...
Hi,
Is there any formula to count the number of days in the quarter.

e.g if I have a date Feb6, 2007 in one cell, I want to populate
corresponding cell with number of days in Q1 2007 (90 days).

Please help me in this.

Thanks,
Mahesh