Convert date from one cell to text in another cell

Bryce Merrill

Hello,

I am trying to convert a date in one cell to text in another cell, but have not been able to figure out an eloquent/simple formula to do so.

The use case is: I have a planned start date column where the cells are populated with dates. I want to have that date translated into a Month label (drop down) in another column within the same row. So for example, my Planned Start Date is 1/15/2021, I want the "Month" column to show January in the cell on the same row.

Thanks!

Paul Newcome

The most straighforward soultion would be a nested IF statement.

=IF(MONTH([Start Date]@row) = 1, "January", IF(MONTH([Start Date]@row) = 2, "February", IF(MONTH([Start Date]@row) = 3, "March", ..................................., "December"))))))))))

Paul Newcome

The most straighforward soultion would be a nested IF statement.

=IF(MONTH([Start Date]@row) = 1, "January", IF(MONTH([Start Date]@row) = 2, "February", IF(MONTH([Start Date]@row) = 3, "March", ..................................., "December"))))))))))

Bryce Merrill

Worked perfectly, thank you!😀

Paul Newcome

Happy to help. 👍️