Countif with a date in a cell reference

[ermccarthy]

I am trying to write a Countif formula that involves a less than or equal to a date.

I am make it work, if I put the date directly into the formula: =countif(Sheet1!Y:Y, ">=8/22/2013")

However, I can not get it to work when the date reference is in a different cell such as =countif(Sheet1!Y:Y, ">="A1)

I have experimented with placement of the quotation marks, etc, but can not get it to work.

Any help the forum can provide would be greatly appreciate!!!!!!!!!

 

[Marcelo Branco]

Try

=countif(Sheet1!Y:Y, ">="&A1)

M.

 

[ermccarthy]

Ugh....it kills me that it was really that simple!!! Thank you VERY much!!

 

[Marcelo Branco]

Ugh....it kills me that it was really that simple!!! Thank you VERY much!!

You are welcome and thanks for the feedback.

M.

 

[MikeyB3649]

I know this post is nearly a decade old, but can anyone help me understand WHY the solution works?

Thanks to all who see this and assist.