Posted to microsoft.public.excel.worksheet.functions

rhhince[_2_] rhhince[_2_] is offline

external usenet poster

Posts: 48

Remove weekends

I have 2 dates and time:
5/21/2010 11:34 is in A2
5/25/2010 11:34 is in A3

If I subtract them, I get 4 days in cell A4.
I would like to subtract the weekends and give me a total of 2 days.

I came across this before, but forgot how to do it. Any help! Thanks.

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
remove weekends on graphs	Rick in Roanoke	Excel Discussion (Misc queries)	1	September 10th 09 09:00 PM
How to remove weekends from the chart	Saran	Charts and Charting in Excel	2	February 24th 09 01:02 PM
Remove weekends from a Chart	Ross12345	Excel Discussion (Misc queries)	0	August 12th 08 10:03 AM
Remove weekends from a stock chart	pb	Charts and Charting in Excel	4	April 14th 07 08:56 PM
How to remove weekends from chart in Excel 2007 ?	GPS	Charts and Charting in Excel	1	April 13th 07 02:34 PM

All times are GMT +1. The time now is 04:49 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us