You could use a Lookup formula or a formula.
=IF(MONTH(B10)>3,"F"&YEAR(B10)+1,"F"&YEAR(B10))
or ="F"&YEAR(B10)+LOOKUP(MONTH(B10),{1,4;0,1})
="F"&YEAR(B10)+(MONTH(B10)>3)&"-"&LOOKUP(MONTH(B10),{1,2,3,4,5,6,7,8,9,10,11,12;10,11,12,1,2,3,4,5,6,7,8,9})
or A Lookup table to accommodate special month-end dates
This message was edited by Dave Patton on 2002-10-08 19:03