How to use NETWORKDAYS in MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to add 6 working days to certain date, excluding weekend and pub.
holidays in Australia calender.

thanks

mamdouh girgis
 
The weekends are easily calculated, but for the holidays, it will help
greatly if you have a list of them, such as a Table that contains only
one Date/Time field, with a record for each holiday that lists that
date. For example:

[Holidays] Table Design View:

[DateOfHoliday]
---------------
1 Jan. 2006
25 Dec. 2006
...

Do you have, or can you construct, such a list of dates?

(BTW, are the "Pub Holidays" those days on which everyone gathers
together to have a good time at the ...? Oh, never mind.)

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.
 
You must log in or register to reply here.

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

Net Work Days in Access? 1
counting days worked per month 5
Count Networkdays 1
Creating a due date but exclude Bank holidays and weekends 3
Calculate days help 2
Total Leave 4
Networkdays function in Access 7
Networkdays Function in Access? 6

Back
Top