Displaying a date in a non-date column

Options
Ben Donahue
Ben Donahue ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

I am trying to display the earliest  date in the "Start" column and the latest date in the "Finish" column, thereby getting the start and end dates of the whole project. I can get these, and display them in a third column formatted as a "date" column. Now, I want to include this text (the date) in a forth column formatted as text. I though there might be some kind of "VALUEOF" formula that would grab the date as a string and display it as such, but cannot find this method, or formula).

My question is, is there any way to display a date in a column formatted as text?

Thank you.

(My next question will be about how to find the number of workdays between two dates)

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!