Skip holidays falling between two dates

A

amit

I want to skip holidays while counting days from start date to finish date.

Example:

If I want to add 3 working days to 15-Apr-2005 (Friday),
I should get 20-Apr-2005 and not 18-Apr-2005.

Skipping 16-Apr-2005 (Saturday) and 17-Apr-2005 (Sunday).

Can someone help me out, please?

Thanks in advance for your replies.
 
N

Niek Otten

Use the Networkdays() function. Look in Help for details.
This is an Analysis Toolpak function. If it is not available: Tools>Add-ins,
check Analysis Toolpak

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate End Date Using Start Date and No. of Days excluding specific days. 0
table lookup 5
Adding up the number of times a month is in a column 1
Difference between last date of month and given date 3
Problem formatting dates from CSV file 2
Countif using dates 11
How to total itmes if they fall between a date range 1
Count cells with a date falling within a 30 day period. 2

Top