Ignore Weekends...

[kdm3]

Hello everybody,

Was wondering if anyone knew of a way of creating a calender which only counts working days. The motivation being that when a ,for example, delivery time is quoted, this usually refers to working days, hence when determining what day this delivery is due, it will be the current date plus 'x' working days - so basically is there a way of ignoring Saturday and Sunday from Date Calcs?

It been kinda bothering me for a long time, so an input would be appreciated.

 

[Late4Supper]

Check this out in the Code repository
http://www.access-programmers.co.uk/forums/showthread.php?t=62237

It adds work days to a given date and allows you to specify Holidays also

 

[kdm3]

That's done the trick...

Yo dude, thanks alot. I used the concept employed in the code and wrote a compact, and efficient little function to achieve exactly what I wanted!