Hello everyone,

This might be simple but I’m stuck:

Name Date
Nam1 02/18/07
Nam2 02/18/09
Nam3 03/14/10
Name4 05/06/2006

Cut off date is 01/18/2006 “Date(2008,01,18)"

Now I need to find how many are +1 year, +2 year and so on until +5
years
The formula I’ve trying to use is
For +1 year
=SUMPRODUCT((Name<"")*(DateDATE(2006+1,1,18)*(Da te<DATE(2006+2,1,18))))
For +2 year:
=SUMPRODUCT((Name<"")*(DateDATE(2006+2,1,18)*(Da te<DATE(2006+3,1,18))))


And so on until 5th

But for some reason it is not working … agrrrRRr!!!

What I’m doing wrong?

In other words from a table I have to find how many people will reach
or reached yearly milestones for 5 years starting 01/18/2006. It is
yearly not by exact date. So if reaches 1 year after 01/18/2007 but
before 01/18/2008 it will still count as 1 year.

I hope I was clear
Thanks

FG