Specific date + 5 working days (result would be Specific_date + 7) - how to do it?

[Paul_Tulcea]

Hi,
I searched in the last 3 days all forums and decided to create an account and ask here:
I am trying to get to a formula that would help me to do the following (1st is mandatory, 2nd is optional).

1. Starting with a specific date I would like to add working days. (To this new date will add again another number of working days and so on). For example, if we have "08.May.2014" + "2 working days" = "12.May.2014"

2. If possible, I would like to have working hours. for example, let's say the working hours start at 08:00 and end at 16:00. If we have "08.May.2014 08:00" + "12 working hours" = "12.May.2014 12:00"

Any help would be appreciated.

Thank you,
Paul

Later edit: A reboot of VMWare machine solved my issue (workday/workday.intl function worked excellent). Still, would like the second option too.

[Kaper]

first part is absolutely basic - use

Please Login or Register  to view this content.

[Paul_Tulcea]

Indeed, it works. I tried with workday and worday.intl and did not work (it counted the weekend days too). After a reboot of VMWare machine is worked. I am not sure about the relationship but it works, thanks.
What about with the second question?

[Kaper]

It is a bit more complicated, because there are several possible cases - like start date/time on holiday etc. You can look at some other threads using search - some propositions: http://www.excelforum.com/excel-form...-and-slas.html and http://www.excelforum.com/excel-form...-included.html etc.