How do I define work days

Question

For one of my formulas, I need to count our specific work days between 2 dates. Our work days are only:SundayMondayTuesdayWednesdayPlease help!

neilschneider · Answer

It's been a while - but what you can do is:Count the number of days between the start and end dates ToDays(startdate - enddate)Divide that number by 7. Multiply by 4 to get the work days in whole weeksThen you need to adjust for the number of days that remain that are work days for example;if there are 10 days in the period, and the first day of the period is Monday.Mo Tu We Th Fr Sa Su Mo Tu WeThen you have 4 work days&nbsp; + Mo Tu We all of which are work days So 7 total work daysBasically the adjustment is calculated as follows:If the first date Mon - If the number of remaining days is less than 7, add 3- If the number of remaining days is less than 3, and all of them...That's the basic formula.&nbsp; ------------------------------Neil Schneider------------------------------

justinfinkelste · Answer

Any advice from someone on this?------------------------------Justin Finkelstein------------------------------

markshnier__you · Answer

I could probably help you , but I don't have any pre-built formula that I can post. We would need to work one on one on a consulting basis.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

justinfinkelste · Answer

Just looking for someone to point me in the right direction. Any help would be amazing!------------------------------Justin Finkelstein------------------------------

paulpeterson2 · Answer

This should give you a good starting point:
If(DayOfWeek(endDate) &gt; 3, 0, ToDays(NextDayOfWeek(startDate, 3) - startDate)) +
(Int(ToDays(If(ToDays(endDate - NextDayOfWeek(endDate, 0)) = 7, endDate, NextDayOfWeek(endDate, 0)) - If(ToDays(NextDayOfWeek(startDate, 6) - startDate) = 7,  startDate, NextDayOfWeek(startDate, 6))) / 7) * 4 )+ If(DayOfWeek(endDate) &gt; 3, 0, ToDays(endDate - PrevDayOfWeek(endDate, 0)))​------------------------------Paul Peterson------------------------------

Forum Discussion

How do I define work days

6 Replies

Related Content

Previous Work Day

Google API QR Codes not working?

%%rid%% has ceased working on mobile - be advised

Time of Day field values are not in 24-hour format in Pipelines

Formula to determine working days in a fiscal month

Recent Discussions

Extrapolating nuanced data

Forms help

Share your feedback on the new Qrew Discussions

Generating QR Code with URL to record

Disappearing Native Tool Bar on Mobile