Forum Discussion
Calculating average days, hours, minutes excluding weekend and holiday
Not sure I catch the question. Format doesn't matter, it only defines how to show values to users. You may take average of such values and display it in any applicable format you wish.
Wondering if there is also a way to calculate the average excluding weekend and holiday?
You may calculate difference between each pair of days using WORKDAY.INTL function (microsoft.com), after that take average of all such differences.
My understanding, workday.intl function is to find the date, after a certain days from the starting date.
That said, I should know the number of days already, I just don't know when the ending date and workday.intl can tell me when the ending date in this scenario.
In my case, I have start date and ending date, what I do not know is the number of days (and hours) between the two dates.
The solution on the thread that I mentioned on my previous message is the solution that is works for me. It can calculate the number of days and hours and I can get the average as well. The problem is, I just realized that I also need to exclude weekend and holidays as well. Any chance you know the answer to this?