Retain Date format when pulling data from another cell
I have one column [End Week Date] that uses a formula to provide the Monday Date of the week a task is supposed to end. This formula works.
I updated the [End Week Date] date format to YYYY-MM-DD.
My issue: I have another column [End Date Week Text] that I use the formula:
="Ending Week Of " + [End Week Date]@row
Expected Result if [End Week Date] = 2022-09-06 should be "Ending Week of 2022-09-06"
Actual Result: "Ending Week of 09/06/2022". This indicates to me that the re-formatting of the [End Week Date] column does not carry through in the text formula.
Any information on how to carry the formatting through would be greatly appreciated.
Help Article Resources
Check out the Formula Handbook template!