Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating days
I'm trying to determine the length fo time ( in days) that we have owned
pieces of equipment. I've found NETWORKDAYS, but this yields a number that is always 10-25% short fo the actual number of days. I've also tried subtracting the two dates but get the reply of "#value". Can anyone help? Thanks. Jason. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating days
NETWORKDAYS excludes weekends. Subtracting the earlier date from the
later date should yield the number of days: strange that you're getting the #Value. Are your dates in serial format? Serial format is Excel's way of handling dates: each day is an integer value. Today, Jan 26 2006, is 38743: you can check this by formatting the date cell as an integer. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating days
"Dave O" wrote in message oups.com... NETWORKDAYS excludes weekends. Subtracting the earlier date from the later date should yield the number of days: strange that you're getting the #Value. Are your dates in serial format? Serial format is Excel's way of handling dates: each day is an integer value. Today, Jan 26 2006, is 38743: you can check this by formatting the date cell as an integer. Only his calculation cells need to be in number format so they make sense to the viewer. The dates used for calculation can remain in normal date format. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating days
Thanks! It was the format of my original date cells. I spent over an hour
in the MS Excell 2000 book, no luck. Thanks again, the knowledge shared witnin this website is awesome! Jason. "Doug Kanter" wrote: "Dave O" wrote in message oups.com... NETWORKDAYS excludes weekends. Subtracting the earlier date from the later date should yield the number of days: strange that you're getting the #Value. Are your dates in serial format? Serial format is Excel's way of handling dates: each day is an integer value. Today, Jan 26 2006, is 38743: you can check this by formatting the date cell as an integer. Only his calculation cells need to be in number format so they make sense to the viewer. The dates used for calculation can remain in normal date format. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating Working Days | Excel Worksheet Functions | |||
Calculating interest on number of days in the period | Excel Worksheet Functions | |||
Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |