Page 1 of 1
Days Between... excluding Sat & Sun
Posted: Tue Jul 07, 2009 9:52 pm
by rickmds
Hi__Similar to the R&R function DAYSBTWN, given 2 dates, I need to calculate the difference excluding Saturdays and Sundays for a company who^s workweek is Monday through Friday. So if date 1 is 6/1/2009 and date 2 is 6/10/2009 the days between would calculate to 7. __Thanks__
=> Days Between... excluding Sat & Sun
Posted: Wed Jul 08, 2009 9:12 am
by kfleming
[updated:LAST EDITED ON Jul-08-09 AT 09:31 AM (EST)]Look at the weekday arithmetic section of __http://www.livewarepub.com/ftp/TechDocs/Creating_User-Defined_Functions.pdf____You can download the udf^s referenced in this article from http://www.livewarepub.com/ftp/TechDocs/rrudf.zip____Kathleen__R&R Support