| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract date, networkdays and sumproduct | Excel Worksheet Functions | |||
| Networkdays with no start date and no end date | Excel Worksheet Functions | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| How do i add networkdays to a date? | Excel Discussion (Misc queries) | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Linear Mode
