If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|