| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date subtraction -How to not show negative when 2nd date not entered
Hi, I have a section of a worksheet that just needs to show working days
between two dates. For example, an order was entered on 9/2/07 and complete on 9/15/07 The formula =NETWORKDAYS(A1, A9) works perfectly except that until the "completed date" ise filled in, a negative number appears. Is there a way to have that remain blank until both dates have been entered? Thanks! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date subtraction -How to not show negative when 2nd date not enter
Hi Edward,
change your formula as =IF(A9="","",NETWORKDAYS(A1, A9)) -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "Edward" wrote: Hi, I have a section of a worksheet that just needs to show working days between two dates. For example, an order was entered on 9/2/07 and complete on 9/15/07 The formula =NETWORKDAYS(A1, A9) works perfectly except that until the "completed date" ise filled in, a negative number appears. Is there a way to have that remain blank until both dates have been entered? Thanks! |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Date subtraction -How to not show negative when 2nd date not entered
=IF(COUNT(A1,A9)=2,NETWORKDAYS(A1, A9),"")
-- David Biddulph "Edward" wrote in message ... Hi, I have a section of a worksheet that just needs to show working days between two dates. For example, an order was entered on 9/2/07 and complete on 9/15/07 The formula =NETWORKDAYS(A1, A9) works perfectly except that until the "completed date" ise filled in, a negative number appears. Is there a way to have that remain blank until both dates have been entered? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If a date entered | Excel Worksheet Functions | |||
| Date Calculations before date entered | Excel Discussion (Misc queries) | |||
| date entered wrong or not as a date | Excel Worksheet Functions | |||
| How do I get a cell to show the day of the week when date entered | Excel Discussion (Misc queries) | |||
| Need date to appear 90 days later than initial date entered | Excel Worksheet Functions | |||
![Edward[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
