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...
Hi Mitchell Are you sure you want to use the function TYPE()? TYPE() does not return a date. https://support.office.com/en-us/article/TYPE-function-45b4e688-4bc3-48b3-a105-ffa892995899?ui=en-US&rs=en-US&ad=US&fromAR=1
You are correct that TYPE is the incorrect Function to accomplish the task at hand. Thank you. I received another reply that TEXT would do what I need to do.