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 |
All times are GMT +1. The time now is 09:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com