Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
Could someone point out where I have gone wrong here. I have 'days since last update' which gives me actual days between A and B but I want to also have working days to exlude weekends. I have used NETWORKDAYS to count the working days (Mon-Fri).
Solved! Go to Solution.
The Networkdays() counts both the start and end days, if they are working days and the calculation is correct. If you want to exclude the start date , use start date+1 or if you want to exclude today, use today()-1 as the end date
Hope this helps
The Networkdays() counts both the start and end days, if they are working days and the calculation is correct. If you want to exclude the start date , use start date+1 or if you want to exclude today, use today()-1 as the end date
Hope this helps
@Padycosmos fantastic, that has sorted it, I had realised it was including the first day. Thanks!
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |