How to use NETWORKDAYS in MS Access

M

mamdouh girgis

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

thanks

mamdouh girgis
 
V

Vincent Johns

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