On Mon, 11 May 2009 03:06:42 -0700, kashish
wrote:

All year divided in 4 quarter as given below

1st quarter is from 28/12/08 to 28/03/09 (13 week)
2nd quarter is from 29/03/09 to 27/06/09 (13 week)
3rd quarter is from 28/06/09 to 26/09/09 (13 week)
4th quarter is from 27/09/09 to 02/01/10 (14 week)

If A column has any date then I want a formula for number of quarter in
column B
For Example
A B
05/01/2009 1
20/03/2009 1
30/03/2009 2
05/06/2009 2
15/07/2009 3
11/09/2009 3
02/10/2009 4
27/12/2009 4

In trying to determine how your quarters are calculated, I note a problem with
your quarter definitions. I should have noticed this before.

Your quarter ending dates are listed as being in both the current and the next
quarter! You need to correct this.

Perhaps you are using ISO weeknumbers to define your quarters?
--ron