amit

Posts: n/a

Skip holidays falling between two dates

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formula to calculate # of days between dates, excluding holidays	abs2299	Excel Discussion (Misc queries)	8	March 3rd 05 02:21 AM
Skip the Holidays 2	Aviator	Excel Discussion (Misc queries)	9	January 13th 05 12:37 PM
Formating Dates for production schedule	dpl7579	Excel Discussion (Misc queries)	1	January 11th 05 08:43 PM
Skip the holidays	Aviator	Excel Discussion (Misc queries)	6	January 11th 05 08:13 PM
due dates	Niki	New Users to Excel	4	January 10th 05 04:11 PM

All times are GMT +1. The time now is 05:08 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us