Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Closed Date < 2 weeks of Open Date etc
I currently have a Dept sheet summing the results from different groups. The
items that I need to capture a 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Day Counting - OPEN & CLOSED | Excel Worksheet Functions | |||
Move entire row of data from open to closed file by entering date | Excel Discussion (Misc queries) | |||
Date - 12 weeks | Excel Worksheet Functions | |||
calculate a date, 10 weeks after a set date | Excel Worksheet Functions | |||
calculate weeks from a start date ( not yr weeks) | Excel Worksheet Functions |