Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am using the NETWORKDAYS function to calculate the number of days between
2 dates. this is fine but i want to turn those days into weeks. i added "/4" to turn the counted days to whole five day weeks. But when i come to add a charge to those weeks, i get a wrong figure. i.e 01/01/05 - 31/01/05 = 4 weeks * £1 = £4.40. when it should be £4.00. is it networkdays formula thats making this error or me? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using Networkdays function problem | Excel Discussion (Misc queries) | |||
networkdays problem | Excel Worksheet Functions | |||
NETWORKDAYS function problem | Excel Worksheet Functions | |||
networkdays() problem when deleting row or column | Excel Worksheet Functions | |||
Networkdays problem | Excel Worksheet Functions |