Month name from date

month01

hello

I'm trying to extract month name from the date column. It has been giving me an error.

che.rabajante

Hello @month01

Please try this:

=
IF(MONTH(Week@row) = 1, "Jan",
IF(MONTH(Week@row) = 2, "Feb",
IF(MONTH(Week@row) = 3, "Mar",
IF(MONTH(Week@row) = 4, "Apr",
IF(MONTH(Week@row) = 5, "May",
IF(MONTH(Week@row) = 6, "Jun",
IF(MONTH(Week@row) = 7, "Jul",
IF(MONTH(Week@row) = 8, "Aug",
IF(MONTH(Week@row) = 9, "Sept",
IF(MONTH(Week@row) = 10, "Oct",
IF(MONTH(Week@row) = 11, "Nov", "Dec")))))))))))

Just replace Column name with the actual column you're using.

Hope this helps

Che