Help with dates

[Guest]

I am trying to make a calculation in EXCEL but cannot make it work - can you
help please?

I have two columns of data which are in dd/mm hh:mm format (the date and
time are important). I need to know the number of days between the two
figures (eg 1.65 days) - a simple subtraction works fine ... BUT ... weekends
get in the way and I want to eliminate weekends from the calculations.

Eg Date/time 1 = 08 Oct 13:00h
Date/Time 2 = 11 Oct 13.00h

The result should be 1.0 days and not 3.0 days.

Any help would be appreciated

Thanks in advance!

 

[Don Guillett]

Have a look in HELP index for WORKDAYS and/or NETWORKDAYS

 

[Guest]

=NETWORKDAYS(A1,A2,B1:B5)

A1 = startdate
a2 = enddate
b1:b5 = range including dates of holidays

Must have the analysis toolpak addin installed

Lance