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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count # days
If testing for same values why not use
=IF(A68=D68,"",your _formula if you use the same dates and the dates are on a weekend date networkdays will return zero whereas it is on a weekday it will return 1 -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Annette" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count # days
Now ... why didn't I think of that (must be an age thing for me!). Yes,
that works "Peo Sjoblom" wrote in message ... If testing for same values why not use =IF(A68=D68,"",your _formula if you use the same dates and the dates are on a weekend date networkdays will return zero whereas it is on a weekday it will return 1 -- Regards, Peo Sjoblom http://nwexcelsolutions.com "Annette" wrote in message ... 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! |
Reply |
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 |