Board index » Excel » calculate how many 'work days' in a month / week

geurinT

calculate how many 'work days' in a month / week

Excel112
hi guys,



currently i have a formula (thanks to this NG) that calculates how

many days there are in a month. is there a way to extend this formula

to calculate the number of work days (mon-fri) there are in that

month?



cheers


-
 
T

Registered User

Wed Nov 07 22:55:38 PST 2007

Re:calculate how many 'work days' in a month / week

Use the NETWORKDAYS function:



=NETWORKDAYS(start_date,end_date)





--

Biff

Microsoft Excel MVP





"Chuck" <cvanoosbree@gmail.com>wrote in message

Quote
hi guys,



currently i have a formula (thanks to this NG) that calculates how

many days there are in a month. is there a way to extend this formula

to calculate the number of work days (mon-fri) there are in that

month?



cheers







-