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

["Tony Butler" <lists@xxxxxxx>]

Not an Excel whizz, but just some thoughts:
define a working day?  Which country are we talking about?
July 4th in US is not, over here it is.
Easter (the usual problematic one) over here we get Fri and Monday off.
US, they only get one - I forget which.
Etc etc.....

Can often be far simpler/cost effective to just have a lookup table with
the days you define to be "non-working".

Just figuring out Mon-Fri, regardless of working/non working status
should be easy enough - Excel is bound to have a day number type
function where 1=Mon, 2=tue etc that you could use.....

HTH,

Tony


> -----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]
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Get A Free Psychic Reading! Your
> Online Answer To Life's Important Questions.
> http://us.click.yahoo.com/Lj3uPC/Me7FAA/ySSFAA>
/IBOolB/TM
>
>
> --------------------------------------------------------------
> -------~->
>
> ** 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/