Calculated Field: Calendar Exceptions

I’m trying to create a calculated field that tells me the number of working days in a Phase. My current formula is:

TO_DURATION({end_date}-{start_date})

Which tells me the total number of real days between the start date and end date, as it should.
I’d like to subtract all non-working days (weekends, Exceptions) specified for the appropriate Project in Work Schedules.

Does anyone have a solution for this?

I’m not sure about creating a dedicated calculated field so I’ll leave that to others, but in the meantime you could just create a task that spans your phase length (start date/due date). It will automatically give you a duration summary that doesn’t include non-working days.

Thanks Pete! I’m specifically trying to make something that lets me quickly assess length in the Project Timeline App, so this won’t work for my purposes, but is a good work around otherwise. :slight_smile: