Quote Originally Posted by dscheeringa View Post
We don't count the end date unless it is the same as the start date. That is the crux of the quandary.
OK, I get that but in the workbook you posted in Post 1 of this thread it's actually the start date that isn't counted - for example see row 27, start date is 29th June and end date is 3rd August, in the helper columns the June column has 1, July has 31 and August has 3, which means you are counting the end date (3rd August), hence 3 days in August, but you're not counting 29th June hence 1 day in June. Is that the way it should be or do you want to count 2 days in June and 2 in August (counting the start date but not the end)?

Also do you want to retain the helper columns or is that just a means to an end, i.e. to get the totals?