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
|