ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Count of Dates (https://www.excelbanter.com/excel-discussion-misc-queries/134536-count-dates.html)

Zoltan

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!

Nikki

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