easy question

  • Thread starter Thread starter Robbie
  • Start date Start date
R

Robbie

I am trying to set up a staff database and I wish to count
the days between two dates, but only ones that are not
weekends or bank holidays.

so between [01/01/04] and [31/01/04]returns a count of 20.

best regards
Robbie
 
Robbie,

(Not really that easy) This may not be much help but a couple years ago I had this same calculation I needed to make. I would count weekdays within a certain date range , then I would calculate how many week day holidays were within the date range and subtract it from the total week days. The first function I believe is possible with supplying parameters to an internal function. The holiday function I made on my own where I could type weekday Holiday dates into a table and it would calculate the number of days it should subtract. If I find my code I will post it here. This may not help but just letting you know how I handled this problem.
 
Back
Top