Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified
Greetings,
I receive a spreadsheet with many tables of data on several worksheets. Each table has two columns Beg Date, End Date. Tables can be 1 to 30 rows in length. What I need to find for each table is the number of unique days. Is there a formula that would do this? I am thinking I would put the formula in the first data row where 392 is in the example and copy it down. Thanks An example of a table is below Beg ..End Unique Days 03/07/06 ..... 04/03/07 .. 392 05/22/06 ..... 11/27/07 ...238 06/15/06 ..... 02/29/08 .. ..94 01/16/07 ..... 04/03/07 .0 04/03/07 ..... 10/26/07 .0 05/18/07 ..... 10/22/07 .0 05/18/07 ..... 11/27/07 .0 05/23/07 ..... 02/29/08 .0 10/22/07 ..... 01/02/08 .0 10/22/07 ..... 05/09/08 70 10/23/07 ..... 12/12/07 .0 10/23/07 ..... 12/04/07 .0 10/25/07 ..... 02/29/08 .0 11/14/07 ..... 11/27/07 .0 12/20/07 ..06/05/08 63 01/01/10 ..02/10/10 .40 Total .. 897 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table "Sum of" or "Count of" | Excel Programming | |||
search for text "beginning with" "containing" wildcards | Excel Worksheet Functions | |||
Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
can we convert "2 days 16 hrs" to " 64hrs" using excel functions | Excel Worksheet Functions |