Dataview calculation for the number of weekdays between 2 dates

[MRobinson-dev]

I looked everywhere for a number of weekdays function but could not find one. so I played around and finally figured this out.

use case, I wanted a dataview query to show the number of weekdays from the day a ticket opened and the day it closed.

I have the following yaml

• startDate
• endDate

in this calculation, if there is no endDate, it uses Today just to show how many days it has been open

1 + 5-startDate.weekday + product([(choice(!endDate, date(today), endDate).weekyear) - startDate.weekyear - 1, 5]) + (choice(!endDate, date(today),endDate)).weekday as DevDays

so basically it adds how many days were there in the 1st week,
then how many days in the full weeks between,
then how many days in the last week (or today).