| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NETWORKDAYS Troubleshoot
NETWORKDAYS should yield a higher count of days as time goes by, but it does
not for some reason. 'Any thoughts? DOUG |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NETWORKDAYS Troubleshoot
It gives you the number of working days between the dates so it increases if
the second date increases but may not if the next date is an holiday. Share the formula you are entering and how you are testing it. "DOUG ECKERT" wrote: NETWORKDAYS should yield a higher count of days as time goes by, but it does not for some reason. 'Any thoughts? DOUG |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NETWORKDAYS Troubleshoot
=NETWORKDAYS(S2,A2). However, I believe the problem was the date format in
the second column (mm-yyy) conflicted with the date format in the first column (dd-mmm-yyy). It seems to work now. Thanks, Sheeloo. DOUG "Sheeloo" wrote: It gives you the number of working days between the dates so it increases if the second date increases but may not if the next date is an holiday. Share the formula you are entering and how you are testing it. "DOUG ECKERT" wrote: NETWORKDAYS should yield a higher count of days as time goes by, but it does not for some reason. 'Any thoughts? DOUG |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NETWORKDAYS Troubleshoot
Date format has nothing to do with it, as all functions, including
Networkdays, ignore the format. Formatting is just for appearance. All functions use the underlying value. Regards, Fred. "DOUG ECKERT" wrote in message ... =NETWORKDAYS(S2,A2). However, I believe the problem was the date format in the second column (mm-yyy) conflicted with the date format in the first column (dd-mmm-yyy). It seems to work now. Thanks, Sheeloo. DOUG "Sheeloo" wrote: It gives you the number of working days between the dates so it increases if the second date increases but may not if the next date is an holiday. Share the formula you are entering and how you are testing it. "DOUG ECKERT" wrote: NETWORKDAYS should yield a higher count of days as time goes by, but it does not for some reason. 'Any thoughts? DOUG |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NETWORKDAYS Troubleshoot
Well, the underlying value in the second column did not include a day in the
date. When I added the day to the date, it worked. Thank you. DOUG "Fred Smith" wrote: Date format has nothing to do with it, as all functions, including Networkdays, ignore the format. Formatting is just for appearance. All functions use the underlying value. Regards, Fred. "DOUG ECKERT" wrote in message ... =NETWORKDAYS(S2,A2). However, I believe the problem was the date format in the second column (mm-yyy) conflicted with the date format in the first column (dd-mmm-yyy). It seems to work now. Thanks, Sheeloo. DOUG "Sheeloo" wrote: It gives you the number of working days between the dates so it increases if the second date increases but may not if the next date is an holiday. Share the formula you are entering and how you are testing it. "DOUG ECKERT" wrote: NETWORKDAYS should yield a higher count of days as time goes by, but it does not for some reason. 'Any thoughts? DOUG |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NETWORKDAYS Troubleshoot
That's because you had text in the cell originally, and changed it to a
number. Formatting had nothing to do with it. Regards, Fred. "DOUG ECKERT" wrote in message ... Well, the underlying value in the second column did not include a day in the date. When I added the day to the date, it worked. Thank you. DOUG "Fred Smith" wrote: Date format has nothing to do with it, as all functions, including Networkdays, ignore the format. Formatting is just for appearance. All functions use the underlying value. Regards, Fred. "DOUG ECKERT" wrote in message ... =NETWORKDAYS(S2,A2). However, I believe the problem was the date format in the second column (mm-yyy) conflicted with the date format in the first column (dd-mmm-yyy). It seems to work now. Thanks, Sheeloo. DOUG "Sheeloo" wrote: It gives you the number of working days between the dates so it increases if the second date increases but may not if the next date is an holiday. Share the formula you are entering and how you are testing it. "DOUG ECKERT" wrote: NETWORKDAYS should yield a higher count of days as time goes by, but it does not for some reason. 'Any thoughts? DOUG |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NETWORKDAYS Troubleshoot
What formula are you using?
What date values are in the cells to which the formula refers? What value did you get from the formula? What value did you expect? Have you ensured that Tools/ Options/ Calculation is set to Automatic, not Manual? -- David Biddulph "DOUG ECKERT" wrote in message ... NETWORKDAYS should yield a higher count of days as time goes by, but it does not for some reason. 'Any thoughts? DOUG |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NETWORKDAYS Troubleshoot
Yes. Thank you.
"Fred Smith" wrote: That's because you had text in the cell originally, and changed it to a number. Formatting had nothing to do with it. Regards, Fred. "DOUG ECKERT" wrote in message ... Well, the underlying value in the second column did not include a day in the date. When I added the day to the date, it worked. Thank you. DOUG "Fred Smith" wrote: Date format has nothing to do with it, as all functions, including Networkdays, ignore the format. Formatting is just for appearance. All functions use the underlying value. Regards, Fred. "DOUG ECKERT" wrote in message ... =NETWORKDAYS(S2,A2). However, I believe the problem was the date format in the second column (mm-yyy) conflicted with the date format in the first column (dd-mmm-yyy). It seems to work now. Thanks, Sheeloo. DOUG "Sheeloo" wrote: It gives you the number of working days between the dates so it increases if the second date increases but may not if the next date is an holiday. Share the formula you are entering and how you are testing it. "DOUG ECKERT" wrote: NETWORKDAYS should yield a higher count of days as time goes by, but it does not for some reason. 'Any thoughts? DOUG |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NETWORKDAYS Troubleshoot
David: The cell contained text. I added a date (or day figure) to the text,
thus converting it to a date and it worked. Thank you. DOUG "David Biddulph" wrote: What formula are you using? What date values are in the cells to which the formula refers? What value did you get from the formula? What value did you expect? Have you ensured that Tools/ Options/ Calculation is set to Automatic, not Manual? -- David Biddulph "DOUG ECKERT" wrote in message ... NETWORKDAYS should yield a higher count of days as time goes by, but it does not for some reason. 'Any thoughts? DOUG |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Troubleshoot help | Excel Discussion (Misc queries) | |||
| troubleshoot a workbook for me? | Excel Discussion (Misc queries) | |||
| troubleshoot absolute value | Excel Worksheet Functions | |||
| Troubleshoot a bug in Excel | Excel Discussion (Misc queries) | |||
| troubleshoot Highlight | Excel Discussion (Misc queries) | |||
![DOUG ECKERT[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
