HI
Maybe try incorporating the LOOKUP function.
=LOOKUP(MONTH(A1+180),{1,2,3,4,5,6,7,8,9,10,11,12} ,{"JA","FE","MR","AL","MA","JN","JL","AU","SE","OC ","NO","DE"})
Alternatively the VLOOKUP can be used as well.
HI
Maybe try incorporating the LOOKUP function.
=LOOKUP(MONTH(A1+180),{1,2,3,4,5,6,7,8,9,10,11,12} ,{"JA","FE","MR","AL","MA","JN","JL","AU","SE","OC ","NO","DE"})
Alternatively the VLOOKUP can be used as well.
Bookmarks