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

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

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

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

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

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

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

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

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

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

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?