customize count/sum formula for overdue dates
- From: "AHizon via OfficeKB.com" <u38169@uwe>
- Date: Fri, 05 Dec 2008 16:40:44 GMT
I have a column with dates that I'd like to use a count formula where it
counts the total number of rows that are past a certain date. How
can I write the formula to calculate this count? Below is an example of what
I mean. A1 is the cell for the date criteria that will determine how many
dates are past due in column B. Column B will have mixture of date and text.
The count should include text as overdue when calculating the number past due.
The answer based on the example below should be 7. Can anyone help me create
this formula?
A1 = 11/25/08
Column B
12/31/08
10/31/08
3/1/13
12/31/08
11/30/08
12/31/08
1/15/09
12/30/08
9/9/09
12/30/08
12/31/08
Not Started
12/30/08
1/30/09
12/31/08
Rqstor on Lv
11/30/08
1/31/09
12/31/08
12/31/08
12/30/08
On Hold
12/30/08
On Hold
12/31/08
12/31/08
10/10/08
1/31/09
12/30/08
11/30/08
1/30/09
4/15/09
TBD
1/30/09
12/31/08
6/30/09
1/31/09
12/15/08
1/31/09
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/excel-functions/200812/1
.
- Follow-Ups:
- Re: customize count/sum formula for overdue dates
- From: T. Valko
- Re: customize count/sum formula for overdue dates
- From: The Code Cage Team
- Re: customize count/sum formula for overdue dates
- Prev by Date: RE: Sifting through multiple matches in vlookup()?
- Next by Date: If Formula in Excel
- Previous by thread: Sifting through multiple matches in vlookup()?
- Next by thread: Re: customize count/sum formula for overdue dates
- Index(es):
Relevant Pages
|
