nth Working Day

[Genx]

What's the easiest way to work out the nth "working day" of a month given that a working day is Monday-Friday?

Edited February 21, 2007 by Guest

[comment]

See if this helps.

[Genx]

So this calculates the nth working day after the current date so if I wanted to find the 5th working day of january, the following should return it.

DatePlusWorkDays ( Date( 1 ; 1 ; 2007 ) ; 4 )

Anyway, you rock, thanks.

[comment]

I think it should be:

DatePlusWorkDays ( Date ( 1 ; 0 ; 2007 ) ; 5 )

It may seem the same thing, but the difference will become obvious when looking for the FIRST working day of a month.

[Genx]

Ah right, that's perfect. Thanks again.