Forum Discussion
TYPE FUNCTION to Merge MM/DD with YYYY
I defined cell A1 to contain 01/01 and cell B1 to contain 2017, both stored as text. Using =TYPE(A1&"/"&B1) it displays as Monday, January 02, 1900. I expected Sunday, January 01, 2017. The Eva...
Mitchell Hogg, the TEXT function will give you what you need
=TEXT(A1&"/"&B1,"dddd, mmmm, dd, yyyy")
Thank you. I used TEXT as described and all is well.
