Lost Ability To Calculate Workdays

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve COR - 29 Feb 2008 16:17 GMT

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

Reply to this Message

Niek Otten - 29 Feb 2008 17:16 GMT

Hi Steve,

What does "does not work" mean?

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

|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

Reply to this Message

Niek Otten - 29 Feb 2008 17:34 GMT

Just read your post again: the syntax is =NETWORKDAYS(B1,B2)

Note the comma instead of the minus sign

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi Steve,
|
[quoted text clipped - 6 lines]
||
|| Thank you in advance Steve

Reply to this Message

Thomas T - 29 Feb 2008 17:36 GMT

Steve the problem is in the formula

"=NETWORKDAYS(B1-B2)"

it is not "-" it is ","
"=NETWORKDAYS(B1,B2)"

Regards

TT

> 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

Reply to this Message

David Biddulph - 29 Feb 2008 17:36 GMT

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?

Signature

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
[quoted text clipped - 4 lines]
>
> Thank you in advance Steve

Reply to this Message

Steve COR - 29 Feb 2008 19:47 GMT

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

> I find it very hard to believe that the formula expressed the way you have
> it has worked in the past.
[quoted text clipped - 9 lines]
> >
> > Thank you in advance Steve

Reply to this Message

Niek Otten - 29 Feb 2008 19:57 GMT

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

Signature

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"
[quoted text clipped - 26 lines]
| > >
| > > Thank you in advance Steve

Reply to this Message

Steve COR - 29 Feb 2008 20:11 GMT

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?

> I don't see what this formula has to do with your original question about NETWORKDAYS().
>
[quoted text clipped - 33 lines]
> | > >
> | > > Thank you in advance Steve

Reply to this Message

Niek Otten - 29 Feb 2008 20:33 GMT

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

Signature

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
[quoted text clipped - 41 lines]
| > | > >
| > | > > Thank you in advance Steve

Reply to this Message

Steve COR - 29 Feb 2008 21:01 GMT

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?

> <back to main point >
>
[quoted text clipped - 54 lines]
> | > | > >
> | > | > > Thank you in advance Steve

Reply to this Message

Gord Dibben - 29 Feb 2008 21:30 GMT

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

>But, back to main point why was it working and now not?

Reply to this Message