Forum Discussion
Solved
Networkdays function is adding an extra day
I'm trying to add a measure to calculate the number of working days between two dates, but the measure I've built adds an extra day. 0 days shows as 1 working days, 1 day as 2 working days and so on....
Stumbled upon this yesterday, too. The documentation says "Returns the number of whole workdays between two dates (inclusive)." So "inclusive" means including the start date. My solutution was to simply subtract one day.
Ah, I did try that but it didn't seem to work with my model. (And didn't seem to fix the issue either).
this did work for mine. Maybe it is where you need to subtract one day is in a different location. I didn't literally write -1 to take out the day. If I needed +3 days, I just wrote +4 days, and doing that adjusted for it counting today in the formula.