| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Can I Count dates without repeating?
I am trying to count dates column without repeating every date twice. For Example: 08/10/05 08/10/05 08/11/05 08/11/05 08/11/05 Answer should be 2. Is it possible in Excel? Thank you for your time. -- bogdan77 ------------------------------------------------------------------------ bogdan77's Profile: http://www.excelforum.com/member.php...o&userid=26204 View this thread: http://www.excelforum.com/showthread...hreadid=395112 |
|
#2
|
|||
|
|||
|
This is an array formula, committed with Ctrol-Shift-Enter. Assumes you
dates are in cells A1:A10 =SUM(1/COUNTIF(A1:A10,A1:A10)) "bogdan77" wrote: I am trying to count dates column without repeating every date twice. For Example: 08/10/05 08/10/05 08/11/05 08/11/05 08/11/05 Answer should be 2. Is it possible in Excel? Thank you for your time. -- bogdan77 ------------------------------------------------------------------------ bogdan77's Profile: http://www.excelforum.com/member.php...o&userid=26204 View this thread: http://www.excelforum.com/showthread...hreadid=395112 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count date occurances in range of dates... | Excel Worksheet Functions | |||
| count number of years 2003 in a range of dates | Excel Worksheet Functions | |||
| How do I count cells in a column of dates between date ranges? | Excel Worksheet Functions | |||
| count dates in excel | Excel Discussion (Misc queries) | |||
| Count occurences between dates | Excel Worksheet Functions | |||
Linear Mode
