I am having trouble with a formula in excel 2007. For example, cell A1 = 8/11/2013, I want result = "Nov". I will use this formula =TEXT(A1,"MMM"). How should I put a condition if I would like to check only from Oct - Dec. Eg. 10/5/2013. ("May"), Anything not from the condition, I will want to have this result "5/10/2013". Pls help. Thank you so much!