Forum Discussion

LC34VAN's avatar
LC34VAN
Copper Contributor
Jan 10, 2021

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...
excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 10, 2021

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

LC34VAN's avatar
LC34VAN
Copper Contributor
Jan 10, 2021

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. 

    • LC34VAN's avatar
      LC34VAN
      Copper Contributor
      Jan 11, 2021

      SergeiBaklan perfect! Thank you so much 

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jan 10, 2021

    LC34VAN 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). 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 

    =NETWORKDAYS(A1,B1)-1

    ... work for you?

     

Resources