So I'm not really sure why this formulas not working. The first part with the FYRef column works fine, but then the
=IF(ISNUMBER([FYRef]),[FYRef], IF(AND([RECEIVEDDATE]>=DATE(2010, 4, 1), (MID([SERIAL],5,2) = "11")), 2011, IF(AND(SEARCH("-11",[SERIAL],0), [RECEIVEDDATE]>=DATE(2010, 04, 01), 2011, 2010))))
Any help would be greatly appreciated.
I believe it's an issue with the SEARCH function.
Thanks,
Bookmarks