Genx Posted February 21, 2007 Share Posted February 21, 2007 (edited) 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 Link to comment Share on other sites More sharing options...
comment Posted February 21, 2007 Share Posted February 21, 2007 See if this helps. Link to comment Share on other sites More sharing options...
Genx Posted February 21, 2007 Author Share Posted February 21, 2007 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. Link to comment Share on other sites More sharing options...
comment Posted February 21, 2007 Share Posted February 21, 2007 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. Link to comment Share on other sites More sharing options...
Genx Posted February 21, 2007 Author Share Posted February 21, 2007 Ah right, that's perfect. Thanks again. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6245 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now