Posted to microsoft.public.excel.misc

The Rook[_2_] The Rook[_2_] is offline

external usenet poster

Posts: 70

Non working days

Is there a formula to calculate the number of non working days between 2
specific dates. For example:

01-01-07 to 31-01-07

No. of Saturdays = 4
No. of Sundays = 4

Cheers

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
5.5 working days	Amy	Excel Discussion (Misc queries)	0	March 22nd 07 03:59 AM
Working days	Andrew Mackenzie	Excel Discussion (Misc queries)	8	January 3rd 07 02:39 PM
Working Days	Mike Hebblewhite	Excel Discussion (Misc queries)	1	January 30th 06 11:49 AM
Working Days	Mike Hebblewhite	Excel Discussion (Misc queries)	0	January 30th 06 11:00 AM
How to Add 5 working days	Trying2Learn	Excel Discussion (Misc queries)	1	June 20th 05 12:52 PM

All times are GMT +1. The time now is 07:15 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us