#1   Report Post  
ann
 
Posts: n/a
Default

Thanks to all who replied. It only happens intermittently so maybe it is
something with the spreadsheet. It is very old and has several anomalies.
--
TIA, Ann


"ann" wrote:

I have a networkdays equation that equals zero sometimes and equals one other
times when the start and end dates are the same. All of my date fields are
formatted as m/d/yyyy.

start date end date #days
8/4/2005 8/4/2005 1
8/16/2005 8/16/2005 0

--
TIA, Ann

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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() not avaialbe after reopening Stan Excel Worksheet Functions 2 June 19th 05 04:53 PM
NETWORKDAYS function problem Arvi Laanemets Excel Worksheet Functions 5 April 19th 05 08:10 AM
networkdays Liesel1 Excel Worksheet Functions 3 January 17th 05 06:49 PM
Networkdays shows as #NAME even though I have the toolpack instal. mark Excel Discussion (Misc queries) 1 December 1st 04 09:13 PM
MS Excel Function - Networkdays Nilesh Inamdar Excel Worksheet Functions 3 November 26th 04 07:10 PM


All times are GMT +1. The time now is 05:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"