Date Difference - Networkdays function not working

[John]

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

 

[Guest]

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

 

[Gord Dibben]

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

 

[John]

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

 

[Ron Rosenfeld]

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

 

[Nooruddin Surani]

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/excel-datediff-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/tutorial...9-aa2edb23422e/custom-sorting-with-icomp.aspx

 

[David Biddulph]

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.