Sheikh Saadi

Posts: n/a

Date Function

I have two columns of Dates. I need a result of Date 2 minus Date 1. This is
pretty simple. this will tell me the number of days. But I need the result to
show me only Business days (i.e., Number of Days in result with no Weekends
--- Saturday and Sunday, excluded).

Please help.

Regards,
Sheikh Saadi

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
Need help with a date function formula	KAA	Excel Discussion (Misc queries)	2	August 29th 05 04:30 PM
Date function	Dee	Excel Worksheet Functions	2	July 13th 05 03:32 PM
Excel date function	Excel date range function	Excel Worksheet Functions	6	June 15th 05 01:59 PM
Is there a function to show future date	taxmom	Excel Worksheet Functions	2	March 4th 05 09:23 PM
Date Function	drschieff	Excel Worksheet Functions	1	January 19th 05 07:51 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us