You could try this (note the use of quote marks... the 1* is to convert the date text into a real date)...I have dates in col A. In col B, I want to write an IF statement that says:
=if(A1<2/11/13,Jan,Feb). I know that this is not a valid formula and I get a NAME error. Can someone help me write the statement correctly? Thanks!
Great! Sorry about the 14 for 13 typo... not sure how that happened, but I am glad you saw through it and corrected for it.Thanks for your help. I think I have it licked!!