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