|
Lost Ability To Calculate Workdays
I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the
workdays in-between two dates. It has worked fine, but all of a sudden now it will not work. I checked the Add-Ins and they are still there. Has anyone ran across this problem before? Thank you in advance Steve |
Lost Ability To Calculate Workdays
Hi Steve,
What does "does not work" mean? -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve COR" wrote in message ... |I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the | workdays in-between two dates. It has worked fine, but all of a sudden now it | will not work. I checked the Add-Ins and they are still there. Has anyone ran | across this problem before? | | Thank you in advance Steve |
Lost Ability To Calculate Workdays
Just read your post again: the syntax is =NETWORKDAYS(B1,B2)
Note the comma instead of the minus sign -- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... | Hi Steve, | | What does "does not work" mean? | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | "Steve COR" wrote in message ... ||I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the || workdays in-between two dates. It has worked fine, but all of a sudden now it || will not work. I checked the Add-Ins and they are still there. Has anyone ran || across this problem before? || || Thank you in advance Steve | | |
Lost Ability To Calculate Workdays
Steve the problem is in the formula
"=NETWORKDAYS(B1-B2)" it is not "-" it is "," "=NETWORKDAYS(B1,B2)" Regards TT "Steve COR" wrote: I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the workdays in-between two dates. It has worked fine, but all of a sudden now it will not work. I checked the Add-Ins and they are still there. Has anyone ran across this problem before? Thank you in advance Steve |
Lost Ability To Calculate Workdays
I find it very hard to believe that the formula expressed the way you have
it has worked in the past. Excel has a feature called "help"; why not type the name of the function NETWORKDAYS into help (or click on fx alongside the formula bar) and see what the syntax ought to be? -- David Biddulph "Steve COR" wrote in message ... I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the workdays in-between two dates. It has worked fine, but all of a sudden now it will not work. I checked the Add-Ins and they are still there. Has anyone ran across this problem before? Thank you in advance Steve |
Lost Ability To Calculate Workdays
I am familiar with the Help feature. here is a formula that did work.
=INT(NOW()-K11)&" Days, "&ROUND((NOW()-K11-INT(NOW()-K11))*24,0)&" Hours" It counted 4 Days, 4 Hours Now useing the same exact foormula nad moving it to a different set of fields to count another date and time, it returns a value of "#VALUE" Why would it have worked in the past and not now when I want to enter new data or use the same formula in a different set of fields? Something happened, and no Help can Help. That is why I am asking in this forum. Occasionally anomolous activity happens and there is no good way to phase your question in a Help feature, so I have come here. Do I need to "Unload" my Add-ins and re-add them? I am at a loss... "David Biddulph" wrote: I find it very hard to believe that the formula expressed the way you have it has worked in the past. Excel has a feature called "help"; why not type the name of the function NETWORKDAYS into help (or click on fx alongside the formula bar) and see what the syntax ought to be? -- David Biddulph "Steve COR" wrote in message ... I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the workdays in-between two dates. It has worked fine, but all of a sudden now it will not work. I checked the Add-Ins and they are still there. Has anyone ran across this problem before? Thank you in advance Steve |
Lost Ability To Calculate Workdays
I don't see what this formula has to do with your original question about NETWORKDAYS().
What do you mean with "moving it to a different set of fields"? Dragging the formula to a different location? Copy and paste? What are the values of the new input cells (cell references have changed in the move/copy process)? Please be more specific -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve COR" wrote in message ... |I am familiar with the Help feature. here is a formula that did work. | =INT(NOW()-K11)&" Days, "&ROUND((NOW()-K11-INT(NOW()-K11))*24,0)&" Hours" | | It counted 4 Days, 4 Hours | | Now useing the same exact foormula nad moving it to a different set of | fields to count another date and time, it returns a value of "#VALUE" | | Why would it have worked in the past and not now when I want to enter new | data or use the same formula in a different set of fields? Something | happened, and no Help can Help. That is why I am asking in this forum. | Occasionally anomolous activity happens and there is no good way to phase | your question in a Help feature, so I have come here. Do I need to "Unload" | my Add-ins and re-add them? | | I am at a loss... | | | "David Biddulph" wrote: | | I find it very hard to believe that the formula expressed the way you have | it has worked in the past. | Excel has a feature called "help"; why not type the name of the function | NETWORKDAYS into help (or click on fx alongside the formula bar) and see | what the syntax ought to be? | -- | David Biddulph | | "Steve COR" wrote in message | ... | I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the | workdays in-between two dates. It has worked fine, but all of a sudden now | it | will not work. I checked the Add-Ins and they are still there. Has anyone | ran | across this problem before? | | Thank you in advance Steve | | | |
Lost Ability To Calculate Workdays
Well guess I should have used the Networkdays formula and stuck with it. But
it is doing the same thing anyway. When I mean by moving the formula to different fiels I mean the copy/paste the formulas, you know, how you can get the formula right once then just propogate it through the rest of the spreadsheet. But, back to main point why was it working and now not? "Niek Otten" wrote: I don't see what this formula has to do with your original question about NETWORKDAYS(). What do you mean with "moving it to a different set of fields"? Dragging the formula to a different location? Copy and paste? What are the values of the new input cells (cell references have changed in the move/copy process)? Please be more specific -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve COR" wrote in message ... |I am familiar with the Help feature. here is a formula that did work. | =INT(NOW()-K11)&" Days, "&ROUND((NOW()-K11-INT(NOW()-K11))*24,0)&" Hours" | | It counted 4 Days, 4 Hours | | Now useing the same exact foormula nad moving it to a different set of | fields to count another date and time, it returns a value of "#VALUE" | | Why would it have worked in the past and not now when I want to enter new | data or use the same formula in a different set of fields? Something | happened, and no Help can Help. That is why I am asking in this forum. | Occasionally anomolous activity happens and there is no good way to phase | your question in a Help feature, so I have come here. Do I need to "Unload" | my Add-ins and re-add them? | | I am at a loss... | | | "David Biddulph" wrote: | | I find it very hard to believe that the formula expressed the way you have | it has worked in the past. | Excel has a feature called "help"; why not type the name of the function | NETWORKDAYS into help (or click on fx alongside the formula bar) and see | what the syntax ought to be? | -- | David Biddulph | | "Steve COR" wrote in message | ... | I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the | workdays in-between two dates. It has worked fine, but all of a sudden now | it | will not work. I checked the Add-Ins and they are still there. Has anyone | ran | across this problem before? | | Thank you in advance Steve | | | |
Lost Ability To Calculate Workdays
<back to main point
The main point is: What exactly is your formula, what are the values of the input cells, what result did you expect and what did you get instead? <why was it working and now not If you change anything (location, input cells, values of the input cells, properties of the input cells like they being text or numbers (the difference is invisible), short: *anything at all*, the results of your formula may change. Please be very specific. You're dealing with computer software, not with an understanding wife or neighbor :-) -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve COR" wrote in message ... | Well guess I should have used the Networkdays formula and stuck with it. But | it is doing the same thing anyway. When I mean by moving the formula to | different fiels I mean the copy/paste the formulas, you know, how you can get | the formula right once then just propogate it through the rest of the | spreadsheet. | | But, back to main point why was it working and now not? | | "Niek Otten" wrote: | | I don't see what this formula has to do with your original question about NETWORKDAYS(). | | What do you mean with "moving it to a different set of fields"? Dragging the formula to a different location? Copy and paste? | What are the values of the new input cells (cell references have changed in the move/copy process)? | | Please be more specific | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | | "Steve COR" wrote in message ... | |I am familiar with the Help feature. here is a formula that did work. | | =INT(NOW()-K11)&" Days, "&ROUND((NOW()-K11-INT(NOW()-K11))*24,0)&" Hours" | | | | It counted 4 Days, 4 Hours | | | | Now useing the same exact foormula nad moving it to a different set of | | fields to count another date and time, it returns a value of "#VALUE" | | | | Why would it have worked in the past and not now when I want to enter new | | data or use the same formula in a different set of fields? Something | | happened, and no Help can Help. That is why I am asking in this forum. | | Occasionally anomolous activity happens and there is no good way to phase | | your question in a Help feature, so I have come here. Do I need to "Unload" | | my Add-ins and re-add them? | | | | I am at a loss... | | | | | | "David Biddulph" wrote: | | | | I find it very hard to believe that the formula expressed the way you have | | it has worked in the past. | | Excel has a feature called "help"; why not type the name of the function | | NETWORKDAYS into help (or click on fx alongside the formula bar) and see | | what the syntax ought to be? | | -- | | David Biddulph | | | | "Steve COR" wrote in message | | ... | | I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the | | workdays in-between two dates. It has worked fine, but all of a sudden now | | it | | will not work. I checked the Add-Ins and they are still there. Has anyone | | ran | | across this problem before? | | | | Thank you in advance Steve | | | | | | | | | |
Lost Ability To Calculate Workdays
Inputs are Date and time : "2/25/2008 8:58:00 AM" in one field the field
next to it has the following formula: "=INT(NOW()-K11)&" Days, "&ROUND((NOW()-K11-INT(NOW()-K11))*24,0)&" Hours"" It returns the value: "4 Days, 5 Hours" Now as you can see by the date I entered that date and time on 25 feb 08 8:58:00 AM, since then actually last two days I have tried to make similair logs in the sheet the next row down I copy-paste the formula and type in the date and time I want, and get "#VALUE!" That is the whole issue....nothing has happened to my computer in the last two days. All I can think of is some system update wiped out something. I did have to add some add-ins to get it to count these days. That is why I think it is a add-in thing. But how do you unload and reload add-ins? "Niek Otten" wrote: <back to main point The main point is: What exactly is your formula, what are the values of the input cells, what result did you expect and what did you get instead? <why was it working and now not If you change anything (location, input cells, values of the input cells, properties of the input cells like they being text or numbers (the difference is invisible), short: *anything at all*, the results of your formula may change. Please be very specific. You're dealing with computer software, not with an understanding wife or neighbor :-) -- Kind regards, Niek Otten Microsoft MVP - Excel "Steve COR" wrote in message ... | Well guess I should have used the Networkdays formula and stuck with it. But | it is doing the same thing anyway. When I mean by moving the formula to | different fiels I mean the copy/paste the formulas, you know, how you can get | the formula right once then just propogate it through the rest of the | spreadsheet. | | But, back to main point why was it working and now not? | | "Niek Otten" wrote: | | I don't see what this formula has to do with your original question about NETWORKDAYS(). | | What do you mean with "moving it to a different set of fields"? Dragging the formula to a different location? Copy and paste? | What are the values of the new input cells (cell references have changed in the move/copy process)? | | Please be more specific | | -- | Kind regards, | | Niek Otten | Microsoft MVP - Excel | | | "Steve COR" wrote in message ... | |I am familiar with the Help feature. here is a formula that did work. | | =INT(NOW()-K11)&" Days, "&ROUND((NOW()-K11-INT(NOW()-K11))*24,0)&" Hours" | | | | It counted 4 Days, 4 Hours | | | | Now useing the same exact foormula nad moving it to a different set of | | fields to count another date and time, it returns a value of "#VALUE" | | | | Why would it have worked in the past and not now when I want to enter new | | data or use the same formula in a different set of fields? Something | | happened, and no Help can Help. That is why I am asking in this forum. | | Occasionally anomolous activity happens and there is no good way to phase | | your question in a Help feature, so I have come here. Do I need to "Unload" | | my Add-ins and re-add them? | | | | I am at a loss... | | | | | | "David Biddulph" wrote: | | | | I find it very hard to believe that the formula expressed the way you have | | it has worked in the past. | | Excel has a feature called "help"; why not type the name of the function | | NETWORKDAYS into help (or click on fx alongside the formula bar) and see | | what the syntax ought to be? | | -- | | David Biddulph | | | | "Steve COR" wrote in message | | ... | | I have had this formula forever. "=NETWORKDAYS(B1-B2)" It counts just the | | workdays in-between two dates. It has worked fine, but all of a sudden now | | it | | will not work. I checked the Add-Ins and they are still there. Has anyone | | ran | | across this problem before? | | | | Thank you in advance Steve | | | | | | | | | |
Lost Ability To Calculate Workdays
Works for me in xl2003
With a valid date of 01/01/2008 in K11 the formula returns 59 Days, 13 Hours Is the date in K11 valid? Is calculation set to automatic? Gord Dibben MS Excel MVP On Fri, 29 Feb 2008 12:11:01 -0800, Steve COR wrote: But, back to main point why was it working and now not? |
| All times are GMT +1. The time now is 05:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com