|
|
#1
05-19-2019, 07:05 AM
|
|||
|
|||
Count the Number of Cells Containling Dates
I have a one-column list that contains 10 cells of dates. Some of the cells are empty. I would like a formula that gives me the total number of cells that have dates in them.
For example, if cells A1 through A5 have dates, and cells A6 through A8 are empty, and cells A9 through A10 have dates, the result of the forumla would be 7. How can I do this? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 count the number of text in a cell based off a different cells text
|
Kubi | Excel | 4 | 08-24-2017 05:53 PM |
|
count a number of cells based on the beginning of a order number
|
Kubi | Excel | 2 | 08-06-2017 08:54 PM |
| Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug) | slaycock | Word VBA | 0 | 02-18-2017 07:00 AM |
| How to Count from Different Cells? | Shahzad | Excel | 3 | 06-26-2010 01:06 AM |
| Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
Windows 10 
Office 97-2003
Threaded Mode