Days in a specific month
 

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

Days in a specific month
 

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

Days in a specific month
 

If you have to select the middle month from a 3 months period (like 09 from
08,09,10 in your example) then
=NETWORKDAYS(IF(MONTH(A1)<MONTH(B1);DATE(YEAR(B1); MONTH(B1)-1;1);A1);IF(MONTH(A1)<MONTH(B1);DATE(YEAR(B1);MONT H(B1);0);B1))
Regards,
Stefi

€žDubboPete€� ezt Ã*rta:

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