Hi All
I am struggling with a formula to return me the year of assessment if the date falls between such and such date.
I used the below. But I cannot continue to add more years...
=IF(AND(C2>=$H$14,C2<=$H$25),"YOA 2001/2002",IF(AND(C2>=$H$26,C2<=$H$37),"YOA 2002/2003"))...