Hi, I’ve got a formula calculating the number of days between a start and end date for tasks/projects, however it currently calculates number of total days, and I need it to calculate based on total WORKING days- and we have a unique work week as well- usually M-TH, not M-F. I can’t seem to find out how to work this into my base. Please help? Current formula for calculating total days is: IF( AND(Start, End), WORKDAY_DIFF(Start,End))
This would work fine if it were a M-F week, but it’s not.
Thank you for any and all advice!!
WORKDAY_DIFF can take a list of holidays, formatted as a comma-separated string of ISO-formatted dates. You can include the dates for Fridays in that list of holidays. The exact format is in the formula field reference.
You will need to eventually update the formula when you reach the end of the Fridays that you include, but formulas can be very long–you could easily include all the Fridays in a year, as well as any other holidays in the year.