WorkDays Differece

[Dave]

Is there a way to calculate the number of days between a start date and an
end date, and if possible holidays and weekend to be excluded, without using
the analysis tool pack (ie network days). I use cytrix server at work and it
doesnt seem to like addons.

Please help

Dave

 

[Andy Brown]

I used to have to do this, with a very clunky method.

In column A, a list of valid dates (Sats, Suns, holidays stripped out).

In D1, a start date ; in D2, an end date.

In some other cell,

=MATCH(D2,A:A)-MATCH(D1,A:A)

HTH,
Andy