Forum Discussion
Trouble converting date while using CONCATENATE function Excel 2007
I have a small spreadsheet that I pull from into another tab (sheet). I have got the CONCATENATE function working except in the date cell. I have tried all the things found wqhen searching and it jus...
Hi Paul,
Dates in Excel are sequential numbers starting from January 01, 1900. Formatting the cell as date you only change the representation. In your formula Excel correctly returns 42957 what is the value for August 10, 2017.
Use in formula TEXT(mainsheet!O3,"yyyy-mm-dd") instead of mainsheet!O3 (or with format you use for dates)