Hello, I'm stuck trying to figure out how many workdays exist in a given month. It is easy enough to get the number of workdays between a start and end date using the WORKDAY_DIFF() function, and it also seems possible to collect the total number of days per month. However, I have not come across a solution to determine the number of workdays per month. Any help would be appreciated!
+13Hi Cody,
You could use a table with Start Dates and End Dates. Each record would have the start date as the 1st of each month and end date as the last of each month. Then, create a formula column using the WORKDAY_DIFF() function. But I'm not sure if this will help since I don't know your exact application.
If you want to schedule some time with me, here's my Calendly link: https://calendly.com/d/2cd-f86-8r6/30-minute-help-meeting
Jody
+10bruceconsulting wrote:
Hi Cody,
You could use a table with Start Dates and End Dates. Each record would have the start date as the 1st of each month and end date as the last of each month. Then, create a formula column using the WORKDAY_DIFF() function. But I'm not sure if this will help since I don't know your exact application.
If you want to schedule some time with me, here's my Calendly link: https://calendly.com/d/2cd-f86-8r6/30-minute-help-meeting
Jody
Thanks Jody,
I have a table with a list of projects, each with a start and end date as well as total number of hours. The day of the month for both start and end dates vary depending on the project. While it's easy enough to obtain the number workdays for the entire time span, what eludes me is how to get the number of workdays per month, so that it is then possible to determine the number of hours per month.
+28Hmm, assuming you've got a "Date" field per record that would be used to determine the month in question, you could try:
WORKDAY_DIFF(
DATETIME_PARSE(
YEAR(Date) & '-' & MONTH(Date),
'YYYY-MM'
),
DATEADD(
DATEADD(
DATETIME_PARSE(
YEAR(Date) & '-' & MONTH(Date),
'YYYY-MM'
),
1,
'month'
),
-1,
'day'
)
)
Adam, Consultant @ The Time Saving Co
1 person likes this
+10TheTimeSavingCo wrote:
Hmm, assuming you've got a "Date" field per record that would be used to determine the month in question, you could try:
WORKDAY_DIFF(
DATETIME_PARSE(
YEAR(Date) & '-' & MONTH(Date),
'YYYY-MM'
),
DATEADD(
DATEADD(
DATETIME_PARSE(
YEAR(Date) & '-' & MONTH(Date),
'YYYY-MM'
),
1,
'month'
),
-1,
'day'
)
)
Thanks for that Adam. A much cleaner approach to getting total workdays per month than what I tried! But, I'm trying to build out not just the total workdays per month; I'm trying to to build out the number of workdays in each month based on when a project starts and ends. Here is an example: Example Project Tracker
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.