IF Formula

[Toastis]

I have a Hire Date and a Termination Date Column. I need to determine the number of employees that were employed (according to these dates) in January 2011. I will repeat the calculation for Feb, Mar, etc.

The formula would need to include those who may have worked in the month and also been terminated in the same month hired.

Ultimately I need a Starting Headcount for the month and an Ending Headcount for the month.

Those still employed here have a term date of 12/31/2049.

Can anyone help?
<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>N</th><th>O</th><th>P</th><th>Q</th><th>R</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Driver ID</td><td style=";">Hire Date Only</td><td style=";">Termination Date</td><td style=";">Jan Start</td><td style=";">Jan End </td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style=";">CAUMO01</td><td style="text-align: right;;">01/24/2011</td><td style="text-align: right;;">01/26/2011</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style=";">ADAJU</td><td style="text-align: right;;">09/16/1996</td><td style="text-align: right;;">12/31/2049</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style=";">ADABR</td><td style="text-align: right;;">11/07/2005</td><td style="text-align: right;;">12/31/2049</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style=";">ADAAA</td><td style="text-align: right;;">06/15/2007</td><td style="text-align: right;;">12/31/2049</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style=";">AGUJO</td><td style="text-align: right;;">08/05/2010</td><td style="text-align: right;;">07/19/2011</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style=";">AGUMA</td><td style="text-align: right;;">09/20/1999</td><td style="text-align: right;;">03/18/2010</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style=";">AGUMI</td><td style="text-align: right;;">07/21/2011</td><td style="text-align: right;;">12/31/2049</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style=";">AGURO</td><td style="text-align: right;;">08/15/2007</td><td style="text-align: right;;">12/31/2049</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style=";">AKEHA</td><td style="text-align: right;;">10/11/2002</td><td style="text-align: right;;">12/31/2049</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style=";">ALLRO</td><td style="text-align: right;;">11/18/1998</td><td style="text-align: right;;">12/31/2049</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style=";">ALVJO</td><td style="text-align: right;;">04/04/2008</td><td style="text-align: right;;">12/31/2049</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style=";">ANDGO</td><td style="text-align: right;;">03/09/2007</td><td style="text-align: right;;">05/14/2010</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style=";">ANDJO</td><td style="text-align: right;;">05/22/2006</td><td style="text-align: right;;">04/01/2009</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style=";">ANDMI</td><td style="text-align: right;;">04/03/2000</td><td style="text-align: right;;">02/07/2009</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style=";">ANDRO</td><td style="text-align: right;;">09/15/2007</td><td style="text-align: right;;">12/31/2049</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style=";">ANTJI</td><td style="text-align: right;;">10/20/2010</td><td style="text-align: right;;">12/31/2049</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Sheet1</p><br /><br />

 

[MrVillareal]

Hi friend

Thanks you appreciate it

 

[MrVillareal]

Excel Workbook
	N	O	P	Q	R	S	T	U	V
1	Driver ID	Hire Date Only	Termination Date	01-Jan-2011	31-Jan-2011	28-Feb-2011	31-Mar-2011	30-Apr-2011	31-May-2011
2	CAUMO01	24-Jan-2011	26-Jan-2011	0	1	0	0	0	0
3	ADAJU	16-Sep-1996	31-Dec-2049	1	1	1	1	1	1
4	ADABR	11-Jul-2005	31-Dec-2049	1	1	1	1	1	1
5	ADAAA	15-Jun-2007	31-Dec-2049	1	1	1	1	1	1
6	AGUJO	08-May-2010	19-Jul-2011	1	1	1	1	1	1
7	AGUMA	20-Sep-1999	18-Mar-2010	0	0	0	0	0	0
8	AGUMI	21-Jul-2011	31-Dec-2049	0	0	0	0	0	0
9	AGURO	15-Aug-2007	31-Dec-2049	1	1	1	1	1	1
10	AKEHA	10-Nov-2002	31-Dec-2049	1	1	1	1	1	1
11	ALLRO	18-Nov-1998	31-Dec-2049	1	1	1	1	1	1
12	ALVJO	04-Apr-2008	31-Dec-2049	1	1	1	1	1	1
13	ANDGO	03-Sep-2007	14-May-2010	0	0	0	0	0	0
14	ANDJO	22-May-2006	04-Jan-2009	0	0	0	0	0	0
15	ANDMI	04-Mar-2000	02-Jul-2009	0	0	0	0	0	0
16	ANDRO	15-Sep-2007	31-Dec-2049	1	1	1	1	1	1
17	ANTJI	20-Oct-2010	31-Dec-2049	1	1	1	1	1	1
18				10	11	10	10	10	10
Sheet21

Excel 2010

Cell Formulas
Range	Formula
Q2	=IF(AND($O2<=Q$1,$P2>=Q$1),1,0)
R2	=IF(AND($O2<=R$1,$P2>=R$1),1,IF(AND(MONTH($P2)=MONTH(R$1),YEAR($P2)=YEAR(R$1)),1,0))

Hi friend

By the way this is my worksheet