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.
 
Back
Top