Excel Text Format to Date

I recently had to format all dates in a specified format mm/dd/yyyy and was struggling with the formats available. I ended up resorting to this simple little text format that worked great!

=TEXT(B2,"mm/dd/yyyy")