![]() |
Count of Dates
I have a column for entering dates. Not every cell has a date entered. Is
it possible to return a count of only the cells in the column which have a date entered into them? i.e. If 6 cells in the column have a date entered, return a count of 6. Thanks for your help. Cheers! |
Count of Dates
if your date coulmn is column A
=COUNT(a2:a100) "Zoltan" wrote: I have a column for entering dates. Not every cell has a date entered. Is it possible to return a count of only the cells in the column which have a date entered into them? i.e. If 6 cells in the column have a date entered, return a count of 6. Thanks for your help. Cheers! |
All times are GMT +1. The time now is 08:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com