Days in a specific month

[DubboPete]

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

 

[T. Valko]

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

 

[Stefi]

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

„DubboPete†ezt írta: