Use the function NETWORKDAYS
--
Brevity is the soul of wit.


"PO" wrote:

Hello,

I need to calculate the number of working days (monday to friday) between
two dates.
For example: the number of working days between 2006-08-25 and 2006-08-28
should be 1, since the 26th and 27th are saturday and sunday. The datediff
function however returns 3.

Is there another function I can use or do I have to write a custom function?

Regards
PO