Help with date formate
I have my months extracted from a date column using =Left(EISD@row,2)
I need a formula to evaluate my month column, if it's 0106 it returns an S, if its 0712 (or <=7) then it returns an F.
Best Answer

Assuming your result will only ever be 0112, this should do the trick. The VALUE() function may not necessarily be needed, but I'm not sure what type of date you are pulling the month information from and it isn't going to hurt anything.
=IF([Month Column]@row <> "", IF(VALUE([Month Column]@row) < 7, "S", "F"))
Replace [Month Column] with your column name.
Answers

Assuming your result will only ever be 0112, this should do the trick. The VALUE() function may not necessarily be needed, but I'm not sure what type of date you are pulling the month information from and it isn't going to hurt anything.
=IF([Month Column]@row <> "", IF(VALUE([Month Column]@row) < 7, "S", "F"))
Replace [Month Column] with your column name.

Thank you Carson, that worked perfectly.
Help Article Resources
Categories
Check out the Formula Handbook template!