Hi! I have two Dates columns, “START” and “END” that specify the start and end dates for a particular task. I have another column that has a WORKDAY_DIFF formula that calculates the working days between these two dates to determine how many days it will take to accomplish this task. However, if “START” and “END” were across different months, how would I separate the working days spent by month?
For example, if the “START” of the task was 10/30/2020 and the “END” of the task was 11/5/2020, the WORKDAY_DIFF between these two dates is 4.0. However, how do I specify/separate the WORKDAYS spent in October (1.0) and the WORKDAYS spent in November (3.0)? Is there a formula, or way I can structure my table to identify how many days per month a task will cost?