D
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
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