If you could post *several* representative samples and the expected results
it would help.

--
Biff
Microsoft Excel MVP


"DubboPete" wrote in message
...
Hi all,

I hve noted there are documented ways to calculate the number of
weekdays in any month, but my enquiry is somewhat different.

I have 5000 rows, with two columns [actual_start] and [actual_end] for
my date ranges, which invariably stay within a calendar month. Easy
enough to calculate the number of weekdays between the two dates
( NETWORKDAYS() ). But, if the two dates go between say 27-Aug-09
and 3-Oct-09, I only want to know the number of weekdays in September.

is this possible, and can anyone advise?

TIA
Pete