Displaying a date in a non-date column
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?
(My next question will be about how to find the number of workdays between two dates)
Help Article Resources
Check out the Formula Handbook template!