Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jan 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Working days calculation (97/2000)

    Does anybody know how to calculate the number of working days between any two input dates ? ..... a BIG plus would be the inclusion of Public Holidays (UK). <img src=/S/igiveup.gif border=0 alt=igiveup width=31 height=23> Nigel

  2. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Working days calculation (97/2000)

    The NETWORKDAYS worksheet function does what you want, but you have to tell it the dates of the holidays!

  3. #3
    New Lounger
    Join Date
    Jan 2002
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Working days calculation (97/2000)

    Excellent, Ian. Thanks ..... ansd so fast !!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •