Hi,

I have a database of employees where column D is their date of joining (in dd-mmm-yyyy format).

I need a formula to arrive at the given values at E1 (Column representing January 2011)

If D1<31,12,2010,0

If D1>31,1,2011,0

If D1 is between 1,1,2011 and 31,1,2011, 10.

Similarly I also need the formula to arrive at the given values in F1 (Column representing February 2011)

If D1<31,12,2010,0

If D1>28,2,2011,0

If D1 is between 1,2,2011 and 28,2,2011, 9.

If D1 is between 1,1,2011 and 31,1,2011, E1.

I need this formula to be copied for each month in G1,H1,etc respectively.

Thanks in advance