| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
Thanks
ce "Aladin Akyurek" wrote: =SUMPRODUCT((Range<"")/COUNTIF(Range,Range&"")) where Range cannot be a whole column reference like A:A. Curtis wrote: Thanks... I forgot t mention that the row could contain the same date but I do not want to count that twice 10-Jul-05 10-jul-05 14-Jul-05 18-Jul-05 18-Jul-05 19-Jul-05 TH answer is still 4 ( the number of dyas worked) thanks ce "Aladin Akyurek" wrote: Wouldn't... =COUNT(DateRange) give you the count you want? Curtis wrote: What formula will calculate the number of days in a row that have different dates 10-Jul-05 14-Jul-05 18-Jul-05 19-Jul-05 Answer s/b 4 Thanks -- [1] The SumProduct function should implicitly coerce the truth values to their Excel numeric equivalents. [2] The lookup functions should have an optional argument for the return value, defaulting to #N/A in its absence. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help to reflect number of days in a month. | Excel Worksheet Functions | |||
| calculating number of days (e.g., Mondays) between two dates | Excel Worksheet Functions | |||
| Number of days since a date | New Users to Excel | |||
| calculate number of working days | Excel Worksheet Functions | |||
| Calculating Production/Man Days in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
