Forum Discussion

Colinahn's avatar
Colinahn
Copper Contributor
Dec 09, 2020
Solved

I need a help with counting days formula!

Hi,

I'm trying to calculate the arriving date that automatically skips weekend and need a help.

 

For example,

If the start date is 12/09, and it takes 10days to arrive,

the arriving date will be 12/19 which is Saturday.

Since Saturday is a weekend, I want it to be displayed as 12/21 which is Monday. 

I tried using WORKDAYS.INTL, but the problem was that it did not count weekend during the shipping period.

What I wanted to do is to automatically avoid showing weekend when it's arriving.

What function should I use to make this work?

 

 

excel
Formulas and Functions
office 365
  • tauqeeracma's avatar
    tauqeeracma
    Steel Contributor
    Dec 09, 2020

    Colinahn Hi

     

    Try below formula, hope it will help

    =IF(WEEKDAY((A2+B2),2)=6,(A2+B2)+2,IF(WEEKDAY((A2+B2),2)=7,(A2+B2)+1,A2+B2))

    A sample file is also attached for your reference.

     

    Please let me know if it works for you.

    Thanks

    Tauqeer

     

    • Colinahn's avatar
      Colinahn
      Copper Contributor
      Dec 09, 2020

      tauqeeracma 

      Hi, Thank you for the reply!

       

      It works great! but if there is TBA schedule, I would like to describe it as "TBD".

      How can I modify your formula that can also show TBD if there is no date confirmed?

      Would IFERROR work?

Resources