Hello All,
trying to calculate how long something is on hire for which is then split between month (Ideally looking for weeks but happy to do month if it can't be done) without including weekends. I have the below where it calculates between a start date and end date (If no end date it uses TODAY() as a running cost) but when I try to get the split it still includes the weekends and I have no idea how to change it to network days.
trying to calculate how long something is on hire for which is then split between month (Ideally looking for weeks but happy to do month if it can't be done) without including weekends. I have the below where it calculates between a start date and end date (If no end date it uses TODAY() as a running cost) but when I try to get the split it still includes the weekends and I have no idea how to change it to network days.