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) |