| 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! |
| 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)
Threaded Mode
