countif question (posted recently in wrong location - sorry)

Contributor

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

@HRGuru55 

Assuming your TODAY() function is in A1:

=COUNTIF(C:C,">=" & A1)
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

@HRGuru55 

It could be

=COUNTIF(C:C, "<" & DATE(YEAR(TODAY()),1,1) )
I obvously misunderstood something - Thanks @Sergei Baklan