Hi,

Go to ToolAdd-Ins and checkAnalysis ToolPak and then use NETWORKDAYS .
Assuming your start date is in A1 end date is in B1 the formula is
=NETWORKDAYS(A1,B1)

Tim


"douwe" wrote:

Hi,

Can anyone help me on the calculation of the time elipsed between start
date/time and end date/time, inculding weekend days and excluding holidays. I
have tried using NETWORKDAYS; but that can't handle the weekend days. Tried
using WORKDAY; but there I cannot subtract the two dates.