how to concatenate date or date of birth in excel by using excel formula .

Concatenate Dates of date of birth in excel,
using some predefined formula, we can get as we need format of date otherwise date will show as number,
Formula- TEXT(column,"yyyy-mm-dd").
With concatenate- = CONCATENATE,(TEXT(column,("yyyy-mm-dd")).

Microsoft Excel.
Microsoft Excel features and formulas.
|| Microsoft excel || MS excel 2010 || MS excel 2013 || MS excel 2016 || MS excel 2019 || MS excel 2007