I have a list of date of birth in col A and in Col B I need to allocate to them a band based on the table below (bands in bold);
<tbody>
</tbody><colgroup><col span="2"><col></colgroup>
To many bands to do an IF or IFS statement, is there another way?
01/09/1997 | 31/08/1998 | N |
01/09/1998 | 31/08/1999 | M |
01/09/1999 | 31/08/2000 | L |
01/09/2000 | 31/08/2001 | K |
01/09/2001 | 31/08/2002 | J |
01/09/2002 | 31/08/2003 | I |
01/09/2003 | 31/08/2004 | H |
01/09/2004 | 31/08/2005 | G |
01/09/2005 | 31/08/2006 | F |
01/09/2006 | 31/08/2007 | E |
01/09/2007 | 31/08/2008 | D |
01/09/2008 | 31/08/2009 | C |
01/09/2009 | 31/08/2010 | B |
01/09/2010 | 31/08/2011 | A |
<tbody>
</tbody><colgroup><col span="2"><col></colgroup>
To many bands to do an IF or IFS statement, is there another way?