Date range and If function

[naaz.peeroo]

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"))


Basically, if the year is from 1 July 2000 to 30 June 2001, the year of assessment is YOA 2001/2002 and so on... till 2013!


Please help me out.

 

[NARAYANK991]

Hi ,


Try this :


="YOA is "&IF(C2>=DATE(YEAR(C2),7,1),YEAR(C2)+1&" / "&YEAR(C2)+2,YEAR(C2)&" / "&YEAR(C2)+1)


where C2 contains a date e.g. 3/13/2000 , the result of the above formula will be :


YOA is 2000 / 2001


Narayan