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

[Chuck]

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. Valko]

Use the NETWORKDAYS function:

=NETWORKDAYS(start_date,end_date)