Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Bradford, Yorkshire, England
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Counting Holidays (All 97/2K)

    Is there a way of calculating the number of holidays that occur between 2 dates. eg I have a table that stores my holidays and want to calculate the no of days between a start and end date but also count the no of holidays separately

    Hope this makes sense.

    Ive looked at DateDiff but this doesnt do what I want.
    Any advice gratefully received

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Counting Holidays (All 97/2K)

    There have been many threads about this subject, but they have been purged recently.

    A combination of How to Find Number of Working Days Between Two Dates and How to Determine If a Date Falls on a Weekend or Holiday should get you what you want.

  3. #3
    Lounger
    Join Date
    Jan 2001
    Location
    Bradford, Yorkshire, England
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Counting Holidays (All 97/2K)

    thankyou

Posting Permissions

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