Count cells with a date

Hi,

as dates are basically numbers, maybe

=COUNT(AK3:AK274)

Or you can write in A1 a start date and in A2 end date

=COUNTIFS(AK3:AK274,">="&A1,AK3:AK274,"<="&A2)

Hope it helps

Ok - is there a way to specify only certain dates?

For example there will be dates from every month but I only want it to count dates from July?
=countif(Ak3:ak274,"july")

start date	end date
6/30/2014	1/1/2015
9/14/2014	1/14/2015
11/15/2014	2/1/2015
blank cell	2 (needs to count only Jan dates)

Hi,

if you mean from first of July 2015, A1 starting date

=COUNTIF(AK3:AK274,">="&A1)

Or


(adjust your date, I'm using a PC with Italian settings)


=COUNTIF(AK3:AK274,">="&"01/07/2015")


Not sure if it's what you need

No, I need it to count how many times July appears in the column
In the example - for end date I need to count how many end dates happened in the month of january

Basically it needs to add up every time the month of July appears regardless of day of the week in the column but ignore all other dates

Hi again,

to count how many times July appears in AK3:AK273

=sumproduct(--isnumber(AK3:AK273),--(month(AK3:AK273)=7))


iF AK3:AK273 contains also strings, a more prudent formula

=SUM(IF(ISNUMBER(AK3:AK273),IF(MONTH(AK3:AK273)=7,1,0)))

Important: the second formula must be confirmed with control+shift+enter.

Hi,

thanks for your kind feedback.

Saluti da Firenze