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