mm/dd/yyyy - display only MM

MilesTHD

I am trying to get a column that will only show me the Month in text, I am referencing Requested_date (in mm/dd/yyyy format). I am using the formula below and i keep getting #unparseable. What i trying to achieve is the following: Column A [Requested_day] = 04/14/2022 then column C [Month] = April. Any suggestions?

=IF(MONTH(Requested_Date]@row = 1, "January") + IF(MONTH(Requested_Date]@row) = 2, "February") + IF(MONTH(Requested_Date]@row) = 3, "March") + IF(MONTH(Requested_Date]@row) = 4, "April") + IF(MONTH(Requested_Date]@row) = 5, "May") + IF(MONTH(Requested_Date]@row) = 6, "June") + IF(MONTH(Requested_Date]@row) = 7, "July") + IF(MONTH(Requested_Date]@row) = 8, "August") + IF(MONTH(Requested_Date]@row) = 9, "September") + IF(MONTH(Requested_Date]@row) = 10, "October") + IF(MONTH(Requested_Date]@row) = 11, "November") + If(Month(Requested_Date]@row) = 12, "December") + " " + DAY([Requested_Date]@row) + " " + YEAR([Requested_Date]@row)

Amanda Alv

Hi there,

Could you confirm if you want just the month in text, or if you want the day and year also? I see you put "April" in the first paragraph but your formula is adding the day and year at the end, so I want to be sure. You were on the right track, just needed to firm up where your ( and [ symbols go. You also do not want to use the + sign, as you are not adding the months, you are just writing multiple different IF statements.

To just receive the Month in text:

=IF(MONTH([Requested_Date]@row) = 1, "January", IF(MONTH([Requested_Date]@row) = 2, "February", IF(MONTH([Requested_Date]@row) = 3, "March", IF(MONTH([Requested_Date]@row) = 4, "April", IF(MONTH([Requested_Date]@row) = 5, "May", IF(MONTH([Requested_Date]@row) = 6, "June", IF(MONTH([Requested_Date]@row) = 7, "July", IF(MONTH([Requested_Date]@row) = 8, "August", IF(MONTH([Requested_Date]@row) = 9, "September", IF(MONTH([Requested_Date]@row) = 10, "October", IF(MONTH([Requested_Date]@row = 11), "November", IF(MONTH([Requested_Date]@row = 12), "December"))))))))))))

To receive the Month in text, Day and year with a comma after the day:

=IF(MONTH([Requested_Date]@row) = 1, "January", IF(MONTH([Requested_Date]@row) = 2, "February", IF(MONTH([Requested_Date]@row) = 3, "March", IF(MONTH([Requested_Date]@row) = 4, "April", IF(MONTH([Requested_Date]@row) = 5, "May", IF(MONTH([Requested_Date]@row) = 6, "June", IF(MONTH([Requested_Date]@row) = 7, "July", IF(MONTH([Requested_Date]@row) = 8, "August", IF(MONTH([Requested_Date]@row) = 9, "September", IF(MONTH([Requested_Date]@row) = 10, "October", IF(MONTH([Requested_Date]@row = 11), "November", IF(MONTH([Requested_Date]@row = 12), "December")))))))))))) + " " + DAY([Requested_Date]@row) + "," + " " + YEAR([Requested_Date]@row)