NetWorkDays - lists as Date??
 

I've recently been switched to Office 2007 and am puzzled on the networkdays
function in this version of Excel. It's not that the function isn't working,
but if I add a -1 outside the function, the results some out as a date, not a
number...

That's strange.... Has anyone a fix for this or do I have to reformat the
cell as number after I enter the function.....


Thanx
Tom

NetWorkDays - lists as Date??
 

Yes, when you have calculated a number of days, you need to format it as a
number, not as a date.
-
David Biddulph

Tom wrote:
I've recently been switched to Office 2007 and am puzzled on the
networkdays function in this version of Excel. It's not that the
function isn't working, but if I add a -1 outside the function, the
results some out as a date, not a number...

That's strange.... Has anyone a fix for this or do I have to
reformat the cell as number after I enter the function.....


Thanx
Tom

NetWorkDays - lists as Date??
 

In the older version of excel it always came up as a number. It does in
2007, until I add the -1, then it changes to a date.... This is what is
puzzling me

"David Biddulph" wrote:

Yes, when you have calculated a number of days, you need to format it as a
number, not as a date.
-
David Biddulph

Tom wrote:
I've recently been switched to Office 2007 and am puzzled on the
networkdays function in this version of Excel. It's not that the
function isn't working, but if I add a -1 outside the function, the
results some out as a date, not a number...

That's strange.... Has anyone a fix for this or do I have to
reformat the cell as number after I enter the function.....


Thanx
Tom

NetWorkDays - lists as Date??
 

I can verify this happening.

Seems odd but it's just a minor inconvience. Just reformat the cell as
General or Number.

--
Biff
Microsoft Excel MVP


"Tom" wrote in message
...
In the older version of excel it always came up as a number. It does in
2007, until I add the -1, then it changes to a date.... This is what is
puzzling me

"David Biddulph" wrote:

Yes, when you have calculated a number of days, you need to format it as
a
number, not as a date.
-
David Biddulph

Tom wrote:
I've recently been switched to Office 2007 and am puzzled on the
networkdays function in this version of Excel. It's not that the
function isn't working, but if I add a -1 outside the function, the
results some out as a date, not a number...

That's strange.... Has anyone a fix for this or do I have to
reformat the cell as number after I enter the function.....


Thanx
Tom

NetWorkDays - lists as Date??
 

Yeah, that's what I have been doing..... Finding a lot of "Minor
Inconvieniences" in this version of Office...

"T. Valko" wrote:

I can verify this happening.

Seems odd but it's just a minor inconvience. Just reformat the cell as
General or Number.

--
Biff
Microsoft Excel MVP


"Tom" wrote in message
...
In the older version of excel it always came up as a number. It does in
2007, until I add the -1, then it changes to a date.... This is what is
puzzling me

"David Biddulph" wrote:

Yes, when you have calculated a number of days, you need to format it as
a
number, not as a date.
-
David Biddulph

Tom wrote:
I've recently been switched to Office 2007 and am puzzled on the
networkdays function in this version of Excel. It's not that the
function isn't working, but if I add a -1 outside the function, the
results some out as a date, not a number...

That's strange.... Has anyone a fix for this or do I have to
reformat the cell as number after I enter the function.....


Thanx
Tom