Date Difference - Networkdays function not working
 

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

Date Difference - Networkdays function not working
 

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

Date Difference - Networkdays function not working
 

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 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

Date Difference - Networkdays function not working
 

On Jul 5, 4:14 pm, 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

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

Date Difference - Networkdays function not working
 

On Thu, 05 Jul 2007 20:14:14 -0000, 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?

Yes

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

Post examples of your formula and your data

--ron

DATEDIF Function Help
 

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

DATEDIF Function Help
 

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
...
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