RE: [OT] Any Excel whizzes out there??

["White, Peter" <peter.white@xxxxxxx>]

It does, now I've added the toolpack. Fanks.

-----Original Message-----
From: Graham Howe [mailto:graham@xxxxxxx]
Sent: 21 June 2003 13:36
To: ukha_d@xxxxxxx
Subject: RE: [ukha_d] [OT] Any Excel whizzes out there??


Make sure you have the Analysis Toolpack add in installed and then have a
look at the NetWorkDays function it should do what you need.

Graham (part time excel whiz)

-----Original Message-----
From: White, Peter [mailto:peter.white@xxxxxxx]
Sent: 21 June 2003 10:28
To: ukha_d@xxxxxxx
Subject: [ukha_d] [OT] Any Excel whizzes out there??

Sorry, I know there's lots of OT posts at the mo, but I've got a bit of an
Excel prob...

I've got a cell working out the number of days between the current date,
and
an entered date (i.e. a date when an action will become due).  This is
"=DAYS360($D$1,D13)", where D1 is todays date and D13 is the
typed due date.
Is there an easy way to have it calculate working days (or even week
days)
rather that straight calendar days?

Thx, Pete



[Non-text portions of this message have been removed]



** UKHA2004 BE THERE! ** - start planning now.

http://www.automatedhome.co.uk
Post message: ukha_d@xxxxxxx
Subscribe:  ukha_d-subscribe@xxxxxxx
Unsubscribe:  ukha_d-unsubscribe@xxxxxxx
List owner:  ukha_d-owner@xxxxxxx

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/