Month / Year out of a date

Paula Cosentino

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!

SBell

Hi Paula

Have a look at the formula in the answer for this post

How To Extract Month And Year Only From A Date and if the date column is blank Return Blank? — Smartsheet Community

hope it helps

Shawn

SBell

Hi Paula

Have a look at the formula in the answer for this post

How To Extract Month And Year Only From A Date and if the date column is blank Return Blank? — Smartsheet Community

hope it helps

Shawn