CountIF

  • Thread starter Thread starter McDuffie
  • Start date Start date
M

McDuffie

I need to count the cells where the date in the cell is
less than 1 year old from the current date. The cells are
formatted as a date.
 
One way:

=SUMPRODUCT((TODAY()-B2:B5<364)*1)

364 or whatever you consider to be the number of
days of a year.
 
Back
Top