Counting cells
 

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.

Counting cells
 

A couple of ways

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

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

change G2:G500 to fit your needs

--


Regards,


Peo Sjoblom



wrote in message
ups.com...
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.