Date formula to find value

[Forestq]

Hi,

I have below table1 (sheet1):

StartDate(A1) <tbody> </tbody>	EndDate(B1) <tbody> </tbody>	Month(C1)	Quater(D1)	Year(E1)
29/07/2012 <tbody> </tbody>	25/08/2012 <tbody> </tbody>	1	Q1	2013 <tbody> </tbody>
26/08/2012 <tbody> </tbody>	22/09/2012 <tbody> </tbody>	2	Q1	2013 <tbody> </tbody>
23/09/2012 <tbody> </tbody>	27/10/2012 <tbody> </tbody>	3	Q1	2013 <tbody> </tbody>
28/10/2012 <tbody> </tbody>	24/11/2012 <tbody> </tbody>	4	Q2	2013 <tbody> </tbody>
25/11/2012 <tbody> </tbody>	22/12/2012 <tbody> </tbody>	5	Q2	2013 <tbody> </tbody>
23/12/2012 <tbody> </tbody>	26/01/2013 <tbody> </tbody>	6	Q2	2013 <tbody> </tbody>
27/01/2013 <tbody> </tbody>	23/02/2013 <tbody> </tbody>	7	Q3	2013 <tbody> </tbody>
24/02/2013 <tbody> </tbody>	23/03/2013 <tbody> </tbody>	8	Q3	2013 <tbody> </tbody>
..	..	..	..	..

<tbody>
</tbody>

Table is filled in this way till 2017.
Now into tab "sheet2" into col A, I have dates:

Dates(A1)	Month (B1)
24/08/2012	1
25/09/2012	3
20/12/2012	5
01/11/2013	6
03/10/2012	3

<tbody>
</tbody>

How to add month value based on table1?

I don't want to do a lot of if....is other way? How to write simple function to fill month based on table1?

 

[Forestq]

yes, working ok...thanks!

 

[Jonmo1]

You're welcome.