Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NETWORKDAYS: using correct funtion?
Hi,
Objective: A work order release is received and I enter that date into cell B8. In cell D5 resides the due date an item is due. In cell C8 I want to calculate the days to the due date (this works). If the date entered is later than the due date, I need to show the days late (this appears to work except I need to show it as a negative number) and that is my problem. This is the formula I'm using, it resides in cell C8: =IF(B8=0,"",(NETWORKDAYS($D$5,B8))) Am I using the right function? If not, can someone point me in the right direction because I am pretty much lost. -- TIA AFJr |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How create my own Funtion | Excel Worksheet Functions | |||
VLOOKUP, correct funtion? | Excel Worksheet Functions | |||
If Funtion | Excel Worksheet Functions | |||
If funtion help | New Users to Excel | |||
IF funtion | Excel Discussion (Misc queries) |