Use the following function to calculate working days:

=NETWORKDAYS(StartDateValue,EndDateValue)

This formula calculates only the Monday through Friday dates.

Optionally, you can enter a range of dates for your holidays so that they
are not counted as working day. If your start date is in A1, the end dat is
in B1 and the range of holiday dates is F1:F10 the formula would look like
this:

=NETWORKDAYS(A1,B1,F1:F10)
--
Kevin Backmann


"SA" wrote:

Hi,

Does anyone know how to calculate working days? I try =workdays(start date,
end date) but it gives me an error #NAME message.

Thanks