count not-overlapping days in a "Table" with Beginning and EndingsDates Specified

J

jb

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top