Counting cells

[seanbtrini]

Hi, I have a sheet with column "G" being the date of the last time a
customer was contacted, I need to count the number of customers that
have been contacted within the last 365 days. I do have the formula
set up on the sheet to keep track of the current date.

Thanks!

Sean.

 

[Peo Sjoblom]

A couple of ways

=COUNTIF(G2:G500,">="&TODAY()-500)

=SUMPRODUCT(--(G2:G500>=TODAY()-365))

change G2:G500 to fit your needs

--


Regards,


Peo Sjoblom