Using: =concatenate(Review Check on , B2)B2 is 4/20/2015, that I created using the date insert shortcut (command+; on Mac).The final cell resolves to Review Check on 42114the /s have been stripped and the number is strange. Anyone knows what's going on?
Calling a date with =concatenate is resolving to strange number
google spreadsheets
All is considered a string when you concatenate elements. Therefore you need to format the text as a date. The following formula does that.Formula=Happy  & TEXT(B2, dd/MM/yyyy) ReferenceGoogle Spreadsheet help, TEXT()