Forum Discussion
Calculating business days
Hi, I am new to excel but need to calculate business days excluding weekends and bank holidays from time received rather than the full start and end date. I.e if the start time is 28-03-2019 15:30 it...
Riny_van_Eekelen Thanks I have tried those but they return 2 full days. I need to be able to start the day part way through and then calculate 24 hours from that time to the next business day so it’s calculated as 1 day rather than 2.
SergeiBaklan perfect! Thank you so much
LC34VAN , you are welcome