Q:

Excel Start date in range within 365 days

Trying to look through an array ($AJ:$AJ) of dates to find dates within 365 days from today and count them.
I know that you can use the INT($AJ:1) to get the serialnumber of the date set.
But unable to do it on an array. 
I need to find eg. 99BIC and count how many times it is in the sheet with dates not older than 365 days
Any ideas how to?
    A   B
1   Application StartDate
2   1023A   20-03-2014
3   1023B   21-03-2016
4   A5GH    21-03-2016
5   99BIC   31-03-2016
6   99BIC   31-04-2015
7   GRIM    06-04-2015
8   BREAK   07-04-2016
9   SACKTWO 17-03-2015

A:

=COUNTIFS(B2:B9,"99BIC",C2:C9,">="&TODAY()-365)

for 365 days or
=COUNTIFS(B2:B9,"99BIC",C2:C9,">="&DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())))

for a calendar year.
So if today is 26/8/16, the first one would not include 26/8/15 since 2016 is a leap year, but the second one would.

