Date calculations.

[deuce]

hi, i am trying to calculate the difference in working days between 2 working day dates.

Is there some way to accomplish counting only monday to friday and excluding saturday and sunday, if the start and end dates are entered?


thanks and regards

deuce

 

[jbeaucaire]

The function you want is called NETWORKDAYS(). It not only counts the M-F workdays for you, you can list "holidays" in a range of cells somewhere, then exlude those dates from the count, too.

 

[deuce]

i will try it thanks.