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