Skip holidays falling between two dates

  • Thread starter Thread starter amit
  • Start date Start date
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.
 
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
Problem formatting dates from CSV file 2
How to total itmes if they fall between a date range 1
Adding up the number of times a month is in a column 1
Difference between last date of month and given date 3
Count cells with a date falling within a 30 day period. 2
Help required in Formula for date 17

Back
Top