Contributor

# countif question (posted recently in wrong location - sorry)

Is there a way to use countif to count the number of cells in a column that are older than the first date of the current year.  (countif(C:C,">=1/1/2021") works but i don't want to have to change formula annually.  I already have a cell with today() in it and would like to reference it.

4 Replies

# Re: countif question (posted recently in wrong location - sorry)

Assuming your TODAY() function is in A1:

``=COUNTIF(C:C,">=" & A1)``

# Re: countif question (posted recently in wrong location - sorry)

Lz, that is counting every cell that is less than today because A1 is today. I need the function that creates the first day of the year, regardless of what day of the year it is.
I am trying to count the number of people who were hired prior to January 1st
Can i use a function in an adjacent cell (ie...B1) that will always be Jan 1, xxxx

# Re: countif question (posted recently in wrong location - sorry)

It could be

``=COUNTIF(C:C, "<" & DATE(YEAR(TODAY()),1,1) )``

# Re: countif question (posted recently in wrong location - sorry)

I obvously misunderstood something - Thanks @Sergei Baklan