It would be very useful to have this functionality rather than convert to numbers through DAY, MONTH, YEAR and back to text through TEXT function.
Best practice would dictate to split these functions out but this increases clutter and causes unnecessary calculations in models.
Thanks for sharing @CallumW this would be very useful and save line items when converting.
This would be a great enhancement! Although you can currently convert using the Day/Month/Year with Text formulas, it would simplify things if there was a formula that directly converted dates to text.
Another vote for this.
The opposite is also highly usable. Most often the data comes as text from files. Need to be able to convert that text to a date using DATE function without having to individually extract Year, Month, Day from the text and then converting it to date format.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.