Three cells lets say A1, B1, and C1.
A1=2012
B1=JAN-1-2012
C1=JAN
Currently i have it set up to fill in C1 automatically with JAN by using =MID(B1,1,3)
What i am hoping to acheive is only fill in C1 with JAN if year reads 2012 by getting from A1, if A1 reads 2013 and B1 reads JAN-1-2012 then C1 is blank. What is formula to achieve this??
Bookmarks