Month / Year out of a date

Options

I'm trying to create a formula to extract Month-Year from a date column.


=IF(MONTH([Date Updated]@ROW) = 1, "Jan-" + RIGHT(YEAR([Date Updated]@ROW), 2), IF(MONTH([Date Updated]@ROW) = 2, "Feb-" + RIGHT(YEAR([Date Updated]@ROW), 2), IF(MONTH([Date Updated]@ROW) = 3, "Mar-" + RIGHT(YEAR([Date Updated]@ROW), 2), IF(MONTH([Date Updated]@ROW) = 4, "Apr-" + RIGHT(YEAR([Date Updated]@ROW), 2), IF(MONTH([Date Updated]@ROW) = 5, "May-" + RIGHT(YEAR([Date Updated]@ROW), 2), IF(MONTH([Date Updated]@ROW) = 6, "Jun-" + RIGHT(YEAR([Date Updated]@ROW), 2), IF(MONTH([Date Updated]@ROW) = 7, "Jul-" + RIGHT(YEAR([Date Updated]@ROW), 2), IF(MONTH([Date Updated]@ROW) = 8, "Aug-" + RIGHT(YEAR([Date Updated]@ROW), 2), IF(MONTH([Date Updated]@ROW) = 9, "Sep-" + RIGHT(YEAR([Date Updated]@ROW), 2), IF(MONTH([Date Updated]@ROW) = 10, "Oct-" + RIGHT(YEAR([Date Updated]@ROW), 2), IF(MONTH([Date Updated]@ROW) = 11, "Nov-" + RIGHT(YEAR([Date Updated]@ROW), 2), IF(MONTH([Date Updated]@ROW) = 12, "Dec-" + RIGHT(YEAR([Date Updated]@ROW), 2), ""))))))))))))

This formula is working in some sheets, but not on the sheet I'm trying today.


Thank you for any help!


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!