Calculate end date with a number of days WITHOUT Weekends / Holidays

Hey friends!

I'm trying to make a somewhat simple function in my excel sheet (Working with 2003). But I can't quite work out how to do it.

What I need to do is:

Calculate and End Date

I have:

- A Start Date
- A variable number of day from a cell (ex. could be "5" or "118").
- And a list of all the dates that are National Holidays

What I need to do is calculate and End Date, but only counting Workdays. ´- I.e. not counting weekends and holidays.


Ex.:
Let's say that Friday 4th May 2012 is a national Holiday, which means 5th & 6th is the weekend.

Today is Wednesday 2nd May 2012.

We want to calculate an end date that is 4 workdays from now. The result should then be: Wednesday 9th May 2012.


The holidays are fixed dates arranged into a range of cells in a column.



I think that's basically it. If you need anymore info don't hesitate ask!

Thx!

If you install the Analysis Tool Pack then you will have access to the NETWORKDAYS function, which will allow you to do this. In later versions of Excel this is built in.

Hope this helps.

Pete

Hi Pete


Thx for the quick response.

I am aware of the NETWORKDAYS function. But it does not provide me with what I am looking for.

What that function returns is "The number of days" given a "Start Date" and an "End Date".

What I need is an "End Date" given a "Start Date" and "The number of workdays" (ie. not counting weekends and holidays).

Originally Posted by martindwilson

try the workday() function

Omg, I had already discarded that function as well. But after taking a second look... You're right. That is exactly what I am looking for.

Thank you!