| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=networkdays formula was working, but not in upgrade to 2003
I have dates when something was requested in column 'o' and when it was
received in column 'q'. I had a formula for calculating the number of days between the two dates and it was working fine. The IT department just upgraded my Microsoft Office to 2003 and now the formula no longer works. Any thoughts? Here's the formula: =IF(ISBLANK(O9),"",IF(ISBLANK(Q9),"",IF(ISBLANK(Q9 ),"",NETWORKDAYS(O9,Q9)-1))) By the way, I also tried the formula stripped down to: =NETWORKDAYS(O9,Q9) and that returned the same error message (which was #NAME? ) Thanks, Marilyn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| protecting formula cells in excel 2003 | Excel Discussion (Misc queries) | |||
| sum formula not working, producing incorrect answers Excel 2003 | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Threaded Mode
