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

Related Content

Jinja Question: Adding business days to today

Calculating number of days between two date fields

Add 1 day to date formula

Address field not working

Maximum Summary field not working