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: ToolsAdd-ins,
check Analysis Toolpak

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"amit" wrote in message
om...
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.

=workday(a1,3)
where A1 holds the date 15-Apr-2005

"amit" wrote in message
om...
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.