counting dates

dayzee · Feb 15, 2006

I have a range of dates that cover many years. I need to be able to count the
dates that are within the last 365 days from the todays date

Bob Phillips · Feb 15, 2006

=SUMPRODUCT(--(A1:A1000>TODAY()-365),--(A1:A1000<=TODAY()))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)