Difference between Start and End dates

**Dyzone** · 07-27-2009, 01:22 PM

Hi guys here I go again, stuck with one problem regarding dates.
I need to compute the no. of days between start and end dates
and spread no. of days on each month.

I've attached a spreadsheet with examples and further explanation.

Appreciate any assistance.

**Dyzone** · 07-29-2009, 06:49 AM

Bump no response

Please let me know if you need more clarification on this problem.

Many Thanks.

**DonkeyOte** · 07-29-2009, 07:14 AM

First off, activate the Analysis ToolPak - Tools -> Addins, this gives you access to some useful Date functions otherwise not available.

Based on your sample...

Inclusive of non-working days:

Please Login or Register  to view this content.

Exclusive of Working Days version:

Please Login or Register  to view this content.

Networkdays also has an optional 3rd parameter to reference a range of public holidays to be excluded in addition to weekends, see XL help for more info.

(note the D10-DAY(D10)+1 could be replaced if preferred with EOMONTH(D10,-1)+1 if preferred)