Hi!

I am trying to combine numbers into different "age" groups. For example groups inside 3 years.
The formula would be:
=IF(AND(A1<2009;A1>2005);1;IF(AND(A1<2006;A1>2002);2;IF(AND(A1<2003;A1>1999);3;"")))
Is there a way to calculate with the current system year without macros?
Something like this:
=IF(AND(A1<current year +1;A1>current year -3);1;IF(AND(A1<curent year -2;A1>current year -6);2;IF(AND(A1<current year -5;A1>current year -9);3;"")))
???

The point is that i would automate the sheet for the next years!
I am trying to avoid changing formulas for each year.
That's why I am trying to include the current year (PC system time) in to calculations!