easy question

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
 
J

Jay

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count non blank cells with a condition? 1
Grouping Periods Of Dates - Sequential and Non-Sequential 6
Creating a due date but exclude Bank holidays and weekends 2
Looking up across date ranges in Access 2
Count specific days in between dates 2
Fill in the date gaps 4
Using the If function for a date range 4
Return multiple records from a single entry. 2

Top