Count the number of overdue dates

[agentFAB]

1. I would like to be able to count the number of overdue dates in a "dates" column - not sure how to do that.

2. And would also like to be able to count the number of dates DUE within 7 days.
any help would be appreciated...

 

[jim may]

Excel Workbook
	A	B
1	11/1/2011
2	10/6/2011	Due in 7 Days
3	8/15/2011	Past Due
4	10/5/2011	Due in 7 Days
5	12/10/2011
6	9/15/2011	Past Due
7	9/30/2011	Past Due
8	10/3/2011	Due in 7 Days
9	11/1/2011
10	10/2/2011	Due in 7 Days
11
12	10/1/2011	<< Enter DUE DATE
13
14	3	Count of Number of records PAST DUE DATE
15
16	4	Count dates Between Cell A12 and 7 days later
Sheet1

Excel 2007

Cell Formulas
Range	Formula
A14	=COUNTIF(A1:A10,"<"& A12)
A16	=COUNTIF(A1:A10,">=" & A12)-COUNTIF(A1:A10,">" & A12+7)

 

[agentFAB]

Thank you so much - that works great!

 

[GTO]

Another try:

Excel Workbook
	A	B	C
1	Dates	Overdue	3
2	09/24/11	Due in 7-	9
3	09/21/11
4	09/18/11
5	09/25/11
6	09/25/11
7	09/17/11
8	09/17/11
9	09/29/11
10	09/29/11
11	09/24/11
12	10/02/11
13	10/01/11
14	09/16/11
15	09/26/11
Sheet5

 

[agentFAB]

Thanks

 

[agentFAB]

Just one more task to complete my spreadsheet...

need to count the number of dates DUE between 8 and 15 days (inclusive)

 

[GTO]

One way (today being 3 OCT 2011)

Excel Workbook
	A	B	C	D
1	Dates	Overdue	Due 7/Less	Due 8 to 15
2	10/24/2011	1	5	5
3	10/16/2011
4	10/16/2011
5	10/9/2011
6	10/16/2011
7	10/19/2011
8	10/6/2011
9	10/23/2011
10	10/16/2011
11	10/24/2011
12	10/11/2011
13	10/6/2011
14	10/7/2011
15	10/1/2011
Sheet1

 

[agentFAB]

great... thanks!

 

[GTO]

You are most welcome and glad that worked