Date Difference - Networkdays function not working

's Computer Specifications

All,

I feel kinda stupid. I can't get this to work. I'm trying to figure
out how to get excel to show the differnece in 2 dates. I have gone
through the help and online tutorials and all I get returned is the
#VALUE to tell me that something is wrong. But I know its right?!?! Is
there something that I'm missing?
I have added the analysis toolpak and using version 2003.
Any suggestions.

John

's Computer Specifications

It would help if we knew what your formulae/data are.

"John" wrote:

> All,
>
> I feel kinda stupid. I can't get this to work. I'm trying to figure
> out how to get excel to show the differnece in 2 dates. I have gone
> through the help and online tutorials and all I get returned is the
> #VALUE to tell me that something is wrong. But I know its right?!?! Is
> there something that I'm missing?
> I have added the analysis toolpak and using version 2003.
> Any suggestions.
>
> John
>
>

's Computer Specifications

Post a small sample of your data and the formula you are attempting.

Maybe DATEDIF would work better to find the difference between two dats?

DATEDIF is undocumented but see Chip Pearson's site for how to use.

http://www.cpearson.com/excel/datedif.htm

Gord Dibben MS Excel MVP

On Thu, 05 Jul 2007 20:14:14 -0000, John <(E-Mail Removed)> wrote:

>All,
>
>I feel kinda stupid. I can't get this to work. I'm trying to figure
>out how to get excel to show the differnece in 2 dates. I have gone
>through the help and online tutorials and all I get returned is the
>#VALUE to tell me that something is wrong. But I know its right?!?! Is
>there something that I'm missing?
>I have added the analysis toolpak and using version 2003.
>Any suggestions.
>
>John

's Computer Specifications

On Jul 5, 4:14 pm, John <john.carbone...@gmail.com> wrote:
> All,
>
> I feel kinda stupid. I can't get this to work. I'm trying to figure
> out how to get excel to show the differnece in 2 dates. I have gone
> through the help and online tutorials and all I get returned is the
> #VALUE to tell me that something is wrong. But I know its right?!?! Is
> there something that I'm missing?
> I have added the analysis toolpak and using version 2003.
> Any suggestions.
>
> John

Sorry to bother guys....I knew It was something small. I figured it
out.
My date was, well lets just say 'wrong'.
Its all 0's and 1's after awhile.

John

's Computer Specifications

On Thu, 05 Jul 2007 20:14:14 -0000, John <(E-Mail Removed)> wrote:

>All,
>
>I feel kinda stupid. I can't get this to work. I'm trying to figure
>out how to get excel to show the differnece in 2 dates. I have gone
>through the help and online tutorials and all I get returned is the
>#VALUE to tell me that something is wrong. But I know its right?!?! Is
>there something that I'm missing?

Yes

>I have added the analysis toolpak and using version 2003.
>Any suggestions.

Post examples of your formula and your data

--ron

's Computer Specifications

DATEDIF function is not related to analysis toolpack its a built in function. The syntax is as follows:

=DATEDIF(start_date, end_date, "interval")

interval could be "d", "m", "y", "md", "ym", you can refer to the following link for more details:

http://www.slideshare.net/nsurani/ex...ediff-function

John wrote:

Date Difference - Networkdays function not working
05-Jul-07

All

I feel kinda stupid. I can't get this to work. I'm trying to figur
out how to get excel to show the differnece in 2 dates. I have gon
through the help and online tutorials and all I get returned is th
there something that I'm missing
I have added the analysis toolpak and using version 2003
Any suggestions

John

EggHeadCafe - Software Developer Portal of Choice
Custom Sorting With IComparable and IComparer
http://www.eggheadcafe.com/tutorials...ith-icomp.aspx

's Computer Specifications

A better link for DATEDIF help is
http://www.cpearson.com/excel/datedif.aspx, and that was given in the July
2007 thread to which you seem to be replying.
--
David Biddulph

<Nooruddin Surani> wrote in message
news:(E-Mail Removed)...
> DATEDIF function is not related to analysis toolpack its a built in
> function. The syntax is as follows:
>
> =DATEDIF(start_date, end_date, "interval")
>
> interval could be "d", "m", "y", "md", "ym", you can refer to the
> following link for more details:
>
> http://www.slideshare.net/nsurani/ex...ediff-function
>
>
>
> John wrote:
>
> Date Difference - Networkdays function not working
> 05-Jul-07
>
> All,
>
> I feel kinda stupid. I can't get this to work. I'm trying to figure
> out how to get excel to show the differnece in 2 dates. I have gone
> through the help and online tutorials and all I get returned is the
> there something that I'm missing?
> I have added the analysis toolpak and using version 2003.
> Any suggestions.
>
> John
>
> EggHeadCafe - Software Developer Portal of Choice
> Custom Sorting With IComparable and IComparer
> http://www.eggheadcafe.com/tutorials...ith-icomp.aspx

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Difference networkdays not accepted in Access.	=?Utf-8?B?RGF2aWRfV2lsbGlhbXNfUEcgKCk=?=	Microsoft Access VBA Modules	2	2nd Aug 2007 04:02 PM
Networkdays function doesn't find true difference between two dat	=?Utf-8?B?c2VzbGVyMg==?=	Microsoft Excel Worksheet Functions	5	5th Oct 2006 02:32 PM
Calculating days between current date and a date in future NETWORKDAYS() function	Faheem Khan	Microsoft Excel Worksheet Functions	2	10th Feb 2005 07:18 PM
Nested IF Function, Date Comparing, and NetworkDays Function	=?Utf-8?B?Y2FybA==?=	Microsoft Excel Worksheet Functions	2	29th Dec 2004 09:57 PM
Networkdays function not working	peterl	Microsoft Excel Worksheet Functions	4	21st Jun 2004 04:14 AM