Autopoluate date information to another cell

jcurry

I would like to autopopulate a cell in another column with the first 3 letters of the month and the last 2 digits of the year that are in the date column that are now displayed as 07/01/25.

Thank you in advance for sharing your wisdom!!

Mark D

Try this:

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

Mark D

Try this:

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

jcurry

Thank you for your quick response! That worked!!