Convert date from one cell to text in another cell

Options
Bryce Merrill
Bryce Merrill ✭✭
edited 01/12/21 in Formulas and Functions

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!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!