Date Difference - Networkdays function not working

  • Thread starter Thread starter John
  • Start date Start date
J

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
 
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
Click to expand...

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
 
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.
Click to expand...

Post examples of your formula and your data

--ron
 
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
 
Back
Top