| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count # days
Here's my formula, but it is resulting unexpected.
=IF((NETWORKDAYS(A68,D68))=1,1,"") I want to eliminate 'same day'. So if the date is 1/1/06 in A68 and 1/1/06 in D68, I don't want a number but rather a blank. My formula indicates 1 when it sees same day. The formula works correctly if cell A has 1/1/06 and cell d has 1/2/06 = 1 Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Total Summed Count of Numeric Repeat (Paired /Double Instance) Criteria | Excel Worksheet Functions | |||
| Formula to count number of days in range which are less than today | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| how do I make a function to count days? | Excel Worksheet Functions | |||
Threaded Mode
