Thread: Work days
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bob Freeman Bob Freeman is offline
external usenet poster
 
Posts: 20
Default Work days

Hello,

I am trying to get a formula that will calculate the number of workdays
(Monday to Friday) between two dates in the following format - if possible
this will also take into account a specified list of holidays (non-workdays),
e.g. 25/12/08, which I can specify in a list.

This will always revolve around date 1 - so if date 2 is after date 1 it
will be a positive number, if date 2 is before date one, it will be a
negative number

For example:

Date 1 Date2 No of working
days from date 1

Monday 2nd Feb Friday 30th Jan -1
Monday 2nd Feb Wednesday 4th Feb 2
Monday 2nd Feb Monday 9th Feb 5


Many thanks.

Bob