Counting Closed Date < 2 weeks of Open Date etc

G

gcw

I currently have a Dept sheet summing the results from different groups. The
items that I need to capture are:

1. How many line items that have closed during the current month and have
closed < 2 weeks of Open Date,
2. Closed between >2 week and < 4 weeks of open date for current month
3. Closed > 4 weeks of open date of current month.

Counting only Weekdays

I have the formula for counting the open and closed, but do not understand
how to count line items that have closed within a current time frame for that
month.

This is my current formula for count “OPEN†line items for month.

=SUMPRODUCT(--(ISNUMBER('[SafetyRegistrationReport.xls]RegisteredItems'!$D$6:$D$205)),--(MONTH('[SafetyRegistrationReport.xls]RegisteredItems'!$D$6:$D$205)=8))

My current formula for count “CLOSED†line items for month is in Column
$G$6:$G$205

I would appreciate any help on completing these functions

Thank you in advance for your help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date diffrence in days, weeks and months. 1
Formula Help 2
Display weeks from a Milestone 0
Counting # of entries for each month, in a specific status 3
use month in cell date to sum all relevant cells 2
IF(AND)Etc..... 3
Counting multiple occcurrences between date range 3
COUNTIF greater than one column and less than another 5

Top