Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
95 | |
93 | |
91 | |
75 | |
69 |