I need to be able to calculate a date span wi...

[Josh_Williams]

I need to be able to calculate a date span with custom parameters. I have a project start date and end date field but also have a field for each day such as “Is Sat a Workday” and “Is Sun a Workday” I need to be able to calculate the number of workdays and non-workdays based on those toggles. Anyone have any suggestions?

[Aleksi_Alkio]

And everything is in that same record? What can be the duration in days? Is there any limit?

[Josh_Williams]

@Aleksi_Alkio Yes everything is in this record. I have a toggle for each day of the week.

[Aleksi_Alkio]

So… the project can last for example few weeks?

[Josh_Williams]

Most small projects last 3-6 weeks. The longest projects are ~18 months.

[Aleksi_Alkio]

Are you asking only Sat and Sat as workdays?