| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| networkdays function stopped working | Excel Worksheet Functions | |||
| Networkdays function is not working between Danish and a Polish PC | Excel Discussion (Misc queries) | |||
| Networkdays function doesn't find true difference between two dat | Excel Worksheet Functions | |||
| Getting XL to Calc Working Days Lost without using NETWORKDAYS() Function | Excel Discussion (Misc queries) | |||
| Networkdays Function Not Working | Excel Worksheet Functions | |||
![John[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
