Formula for calculating turnaround time based on start date and date completed fields

English Forum Ask the Community
1

Is there a formula I can use to only calculate the difference between the date completed and start date in business days? I want to exclude weekends.

I have seen this formula online that I have replicated ( [[date completed]] - [[date started]] ) / 1440

however, this formula does not exclude weekends. I only want the turnaround time (in number format) for weekdays/business days. Is this possible?

2

Hi @Amarpreet_Japra , unfortunately this is not currently possible, although possibly coming soon to the List view, it is currently only available in the Gantt view, if you got to Options in the top right and enable it under Show/hide fields.

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.