pancho

Junior Member

Posts: 1

Networkdays

I can get the number between 2 dates. However if one date is not known (B1) and it stays 0. How do I get the date entered (A1) subtract from the spreadsheet date to get the number of current days.

A1 = Jan 12, 2010
B1 = July 18, 2010
C1= # of days between

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
NETWORKDAYS	Steve 51	Excel Worksheet Functions	3	March 10th 09 08:53 PM
NETWORKDAYS	Connie Martin	Excel Worksheet Functions	9	August 12th 08 01:38 AM
Networkdays	Dave	Excel Discussion (Misc queries)	3	January 13th 07 04:58 PM
networkdays	Christian (DK)	Excel Worksheet Functions	6	November 21st 05 11:32 AM
NETWORKDAYS = 0	ann	Excel Discussion (Misc queries)	4	October 3rd 05 10:07 PM

All times are GMT +1. The time now is 12:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us