Count number of dates present in a column

[Seancsn]

Hi, I'm looking to be able to total the number of dates present in a column. Some of the cells will be empty and other will have a date in them. Do I use COUNTIF or SUMPRODUCT?
Thanks in advance

Sean

[davesexcel]

You can use sumproduct, this example will count cells between two dates, you can adjsut the start date and end date.
=SUMPRODUCT(--(A2:A1000>=DATE(2012,1,1)),--(A2:A1000<=DATE(2012,12,31)))

[DGagnon]

countif will work, just use =countif(A1:A100,">0")

[jstn]

If I understand correctly - you want a total of the number of cells that an entry in them - the code below will count any cell that has a value greater than 0.

Please Login or Register  to view this content.

[vlady]

hello
@ daves formula we can adjust this to : betwenn 2000 - 2050

=SUMPRODUCT(N(YEAR(A1:A100)>=2000),N(YEAR(A1:A100)<=2050))

NOTE: dates are also numbers if you use countif it will include the numbers on the count..

exam.

5
6
11/12/2011
5

=countif() will return 4

[Seancsn]

Thank everyone for your quick response. Much appreciated. I used Dgagnons version in the end. Sean

[jstn]

**Misread prev post