| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Percentage of dates that are 7 days late
I'm trying to create a formula that will give me the Percent of Activities
with Actual Comp. Dtd. (column C) More than 7 Days after Recommended Comp. Dtd. (column B). In the example there may be dates in column B and none in column C these are to ignored. I have thousands of rows so I don't want to add a formuls in another column that determines each one separatly and than sum them up. I need to do it in one step. A B C Act 1 2/3/09 2/5/09 Act 2 6/7/09 7/6/09 Act 3 1/5/09 3/4/09 Act 4 4/3/09 8/9/09 Robert K |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage of dates that are 7 days late
Maybe this:
=SUMPRODUCT(--(C2:C100-B2:B1007))/COUNT(C2:C100) Format as Percentage -- Biff Microsoft Excel MVP "RobertK" wrote in message ... I'm trying to create a formula that will give me the Percent of Activities with Actual Comp. Dtd. (column C) More than 7 Days after Recommended Comp. Dtd. (column B). In the example there may be dates in column B and none in column C these are to ignored. I have thousands of rows so I don't want to add a formuls in another column that determines each one separatly and than sum them up. I need to do it in one step. A B C Act 1 2/3/09 2/5/09 Act 2 6/7/09 7/6/09 Act 3 1/5/09 3/4/09 Act 4 4/3/09 8/9/09 Robert K |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage of dates that are 7 days late
Thanks, I may have another one for you but I like to exhaust all my
possibilites first. -- Robert K "RobertK" wrote: I'm trying to create a formula that will give me the Percent of Activities with Actual Comp. Dtd. (column C) More than 7 Days after Recommended Comp. Dtd. (column B). In the example there may be dates in column B and none in column C these are to ignored. I have thousands of rows so I don't want to add a formuls in another column that determines each one separatly and than sum them up. I need to do it in one step. A B C Act 1 2/3/09 2/5/09 Act 2 6/7/09 7/6/09 Act 3 1/5/09 3/4/09 Act 4 4/3/09 8/9/09 Robert K |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Percentage of dates that are 7 days late
We're always open!
Thanks for the feedback! -- Biff Microsoft Excel MVP "RobertK" wrote in message ... Thanks, I may have another one for you but I like to exhaust all my possibilites first. -- Robert K "RobertK" wrote: I'm trying to create a formula that will give me the Percent of Activities with Actual Comp. Dtd. (column C) More than 7 Days after Recommended Comp. Dtd. (column B). In the example there may be dates in column B and none in column C these are to ignored. I have thousands of rows so I don't want to add a formuls in another column that determines each one separatly and than sum them up. I need to do it in one step. A B C Act 1 2/3/09 2/5/09 Act 2 6/7/09 7/6/09 Act 3 1/5/09 3/4/09 Act 4 4/3/09 8/9/09 Robert K |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Days Late | Excel Discussion (Misc queries) | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| report date - date rec.ved=days late, but how to rid dates complet | Excel Worksheet Functions | |||
| 30, 60, 90 days late and due within 14 days | Excel Discussion (Misc queries) | |||
Linear Mode
