Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
If you have access to Google Sheets, then you can think of it as a very powerful calculation API. In this case, you could send the two dates to a 3-cell row that uses the NETWORKDAYS function to return the value that you need in the format that you want. ~Jeff
Views
Replies
Total Likes
HI Krissy
This is something that i have asked about in the past, and because you cannot perform a calculation such as WEEKDAYDIFF in FUSION i hit a bit of a brick wall.
However there are two ways that this can be addressed (that i am aware of)
Hopefully others may have a better solution, but you can just set up a custom form with these fields in an admin area with the sole purpose being to populate > calculate > clear ready for next use.
Interested to also hear what other options people may suggest
Thanks
Views
Replies
Total Likes
Hi Krissy,
Great question.
Jonathan, thanks for thoughtful approaches.
I don't know if it is "incredibly" complicated, but I suppose you wouldn't want to tackle this on your first day of Fusion. 😃 I'll admit in in my approach, I've taken a very basic understanding of what a "business day" is (as just a weekday). If you need to take into account holidays or other types of things that would not qualify as a "business day"...then, yes -- it will certainly get more complicated.
I've attached a scenario blueprint that shows how to do this and it includes some notes to provide some clarity. In some ways, it helps enforce some great concepts and what is possible with Fusion.
Essentially, you can use a "repeater" to iterate over the days between dates. For each iteration, determine whether that day is a weekday and then use a numeric aggregator to sum the number of days that meet your criteria. (of course, if you used a more nuanced definition of a "business day", then then in the middle you could add additional logic here to filter out days, etc..
Hopefully this helps -- you can import the blueprint and play around with it without hurting anything (also be sure to check out the notes). Cheers.
Views
Replies
Total Likes
If you have access to Google Sheets, then you can think of it as a very powerful calculation API. In this case, you could send the two dates to a 3-cell row that uses the NETWORKDAYS function to return the value that you need in the format that you want. ~Jeff
Views
Replies
Total Likes
OMG that is brilliant!
Views
Replies
Total Likes
Views
Likes
Replies