• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need to add n number of working days in a given date.

D

DJ

Member
Hi All,


I need a help calculating the Turn Around Time. To do this I need to add n number of working days in a given date e.g. if request is raised on Thursday and Turn Around Time is 72 hours i.e. 3 working days then Turn Around Time would be Monday End of Business.


I tried to apply if else conditions but it has become a gient formula and I am lost in it now.


Kindly help

DJ
 
DJ

Try either:

=WORKDAY.INTL(A1,3)

or

=WORKDAY(A1,3)


Workday.Intl is only available in Excel 2010 and beyond
 
Hi Hui,


Thank you so much for the help. I had tried to use Networkdays.INTL but that wasn't helping.


I will try to rewrite the formula and contact again if face any issue.


Thanks a lot,

DJ
 
Don't forget that you can also add Holidays to both versions and Alternate Weekends to the the 2010 version as well
 
You must log in or register to reply here.
Back
Top