ExcelBanter - counting dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - counting dates (https://www.excelbanter.com/excel-worksheet-functions/71742-counting-dates.html)

dayzee

counting dates

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

counting dates

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dayzee" wrote in message
...
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

All times are GMT +1. The time now is 12:11 AM.