Display a Date value by combining General values from other cells in Excel
Posted on 2011-02-14
In Excel (2007), suppose that columns A, B and C have a General format and contain values representing month, day, and year respectively. What formula in column D will combine the A-C values from the corresponding row so that column D will display the full date with the format m/d/yyyy?
If A1 = 3, B1 = 16 and C1 = 2006, then D1 = 3/16/2006
If A2 = 11, B2 = 5 and C2 = 2010, then D2 = 11/5/2010
If A3 = 7, B3 = 31 and C3 = 2008, then D3 = 7/31/2008
and so on...