Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula
The formula is OK, though you could have omitted one unnecessary pair of
brackets and used =IF(ISBLANK(B1),1,NETWORKDAYS(A1,B1)) The answer from NETWORKDAYS with those inputs is 1, however. -- David Biddulph "Dave" wrote in message ... What I want the formula to do is when a start date is entered and no end date for the cell to display a 1. If both a start date and end date is entered then use the networkdays function to calculate the days. I've applied this formula without success: =IF((ISBLANK(B1)),1, networkdays (A1,B1)) Whe A1=24/02/2006, B1=26/02/2006 Therefore the formula should calculate the networkdays=2. If A1=24/02/2006, B1=ISBLANK Then the formula should calculate =1. Does anyone have any ideas to make this work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |