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.

Assume you have:

A1 = month
B1 = day
C1 = year

=DATE(C1,A1,B1)

Biff

"Kip" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>