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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional format Column based on Week Date 2
Concatenate all combinations grouped in columns 1
Dates Within A Range 2
How to enter start and end date/time in excel based on some specific value. 7
compare date range with date in columns and input data from another cell 2
Combining two columns into one X-axis? 1
Group List by Values in Column A and combine related row values inColumn B into 1 Cell 7
Conditional Formatting 7

Back
Top