Posted to microsoft.public.excel.worksheet.functions

Vim

Posts: n/a

Date Calculation to exclude weekends

Pls Help!

I'm trying to subtract a delivery date with order received date and it shows
a value...fine....but how do get the formula to ignore weekends to show a
true working working and more accurate number of delivery days.

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
Date calculation	Box666	New Users to Excel	3	November 4th 05 02:11 PM
NETWORKDAYS - Multiple Date Selection	Annabelle	Excel Discussion (Misc queries)	3	October 4th 05 07:04 PM
Date calculation	USCBrad	Excel Worksheet Functions	3	June 21st 05 04:03 PM
Date difference taking into account weekends.	annonymous	Excel Worksheet Functions	3	March 14th 05 05:35 PM
Date issue between Windows and Macintosh version	dlg1967	Excel Discussion (Misc queries)	4	January 19th 05 03:51 PM

All times are GMT +1. The time now is 06:43 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us