Calculating business days

Question

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 will finish on 29-03-2019 15:29. Any assistance would be much appreciated. Thanks

riny_van_eekelen · Answer

LC34VAN&nbsp;You may look into functions NETWORKDAYS and/or&nbsp;NETWORKDAYS.INTL

lc34van · Answer

Riny_van_Eekelen&nbsp;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.&nbsp;

riny_van_eekelen · Answer

LC34VAN&nbsp;Okay, these functions include the starting date AND the end date. So, both the 28th and the 29th were working days, hence 2 (provided you didn't specify them as public holidays).&nbsp;Excel doesn't know that "your" working day ends 15:29:59 and that the start date should be excluded. But perhaps I don't understand the part of your question: "to start the day part way through".What exactly is it that you want to achieve? Might a formula like&nbsp;=NETWORKDAYS(A1,B1)-1... work for you?&nbsp;

sergeibaklan · Answer

LC34VAN&nbsp;
Perhaps something like

with
=NETWORKDAYS(B3,C3)-(MOD(C3,1)&lt;MOD(B3,1))

lc34van · Answer

SergeiBaklan&nbsp;perfect! Thank you so much&nbsp;

Forum Discussion

Calculating business days

6 Replies

Resources