data formula

[Dummy Excel]

Hi,
Is there a formula that I can use that only calculates the working days (presuming mon - fri are working days only) based on 2 cells in excel (a start date and end date)?

thanks
Sam

 

[AlphaFrog]

The NETWORKDAYS function can do that.

Syntax:
NETWORKDAYS(start_date,end_date,holidays)