This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
There are many ways to count it. But if you think through the logic, you could write it like.. HOUR( EOWEEK([EndDate])-EOWEEK([StartDate]) ) /24 /7 + IFS(WEEKDAY([EndDate)=7,1)
LinkedIn
Twitter
