Counting how many times a due date is missed each month

[justp90]

I have a tab on a worksheet, call it tab B. It has a date issued, a goal close date, and an actual close date. I have another tab, call it tab A. That has the months listed in a row. I need to be able to count each time a date is past goal and put that under the month it was missed in tab A. I really hope I could get some formulas to use. Or ideas.Thanks in advance.

 

[JoeMo]

Maybe something like this I have added a row at the top of Sheet A to contain the month number.

Excel Workbook
	A	B	C
1	Date Issued	Goal Date	Actual Date
2	8/7/2012	8/14/2012	8/17/2012
3	8/8/2012	12/20/2012
4	8/10/2012	8/12/2012	8/11/2012
5	8/15/2012	9/14/2012	9/15/2012
6	8/19/2012	8/25/2012	8/25/2012
B

Drag the formula in A3 across for the setup below:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	1	2	3	4	5	6	7	8	9	10	11	12
2	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
3	0	0	0	0	0	0	0	1	1	0	0	0
A

 

[Akashwani]

Hi and welcome to MrExcel.

Does something like this work for you?....

Excel Workbook
	A	B	C	D
1	Date Issued	Goal Close Date	Actual Close Date	Check
2	02/01/2012	01/03/2012	01/04/2012	01/03/2012
3	20/01/2012	20/03/2012	01/03/2012
4	03/04/2012	03/05/2012	30/08/2012	03/05/2012
5	05/05/2012	05/07/2012	05/07/2012
6	06/01/2012	06/03/2012	01/09/2012	06/03/2012
TabB

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2	0	0	1	0	1	0	0	1	0	0	0	0
TabA

The formulas will need copying across/down.

I hope that helps.

Good luck.

Ak

 

[justp90]

Thank you! That worked perfectly!!!