Days in a specific month

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
 
T

T. Valko

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

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top