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

(Josh Williams) #1

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) #2

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

(Josh Williams) #3

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

(Aleksi Alkio) #4

So… the project can last for example few weeks?

(Josh Williams) #5

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

(Aleksi Alkio) #6

Are you asking only Sat and Sat as workdays?