Days Between... excluding Sat & Sun

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
rickmds
Posts: 38
Joined: Tue Oct 10, 2017 12:44 pm

Days Between... excluding Sat & Sun

Post by rickmds » Tue Jul 07, 2009 9:52 pm

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__

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> Days Between... excluding Sat & Sun

Post by kfleming » Wed Jul 08, 2009 9:12 am

[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

Post Reply