Help with date formate

jpaul

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 01-06 it returns an S, if its 07-12 (or <=7) then it returns an F.

Carson Penticuff

Assuming your result will only ever be 01-12, 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.

Carson Penticuff

Assuming your result will only ever be 01-12, 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.

jpaul

Thank you Carson, that worked perfectly.