Combining Columns in Excel to Create Date

  • Thread starter Thread starter Kip
  • Start date Start date
K

Kip

I have a spreadsheet with three columns showing month born, day born
and year born. I want to combine these 3 columns to create a date in a
single column, like 02/14/1942 so that I can accurately calculate a
persons age as of the current day. I would also like to then calculate
that persons zodiac sign. For example, if I had a birthdate in three
columns showing for January 1st, 1911 (or 01/01/1911) when I try
combining the columns using =A1&B1&C1, I end up with a result like
111911. Thanks.
 
Back
Top