I am looking how to create a function for the following. I have 3 columns
that represent a date. Column one represents the month, Column two
represents the day, and column three represents a year. For example a birth
date (1) 05, (2) 15, (3) 1956. In the fourth column that I will create I
would like to place the function so that I can have similar results of
05/15/1956. I have played around, but I cannot get the numbers right, I am
still getting errors. Any help would be appreciated. Thanks so much.

If you have 05 in column 1 (A) this suggests that it is a text value. So,
you might like to try this:

=DATE(C1*1,A1*1,B1*1)

Then format the cell in the style that you would like to see (custom -
mm/dd/yyyy)

Hope this helps.

Pete

"sweetthing4luc" wrote in message
...
I am looking how to create a function for the following. I have 3 columns
that represent a date. Column one represents the month, Column two
represents the day, and column three represents a year. For example a
birth
date (1) 05, (2) 15, (3) 1956. In the fourth column that I will create I
would like to place the function so that I can have similar results of
05/15/1956. I have played around, but I cannot get the numbers right, I
am
still getting errors. Any help would be appreciated. Thanks so much.

=DATE(C1,A1,B1)

Syntax is Date(year,month,day)


Gord Dibben MS Excel MVP


On Tue, 4 Nov 2008 15:01:03 -0800, sweetthing4luc
wrote:

I am looking how to create a function for the following. I have 3 columns
that represent a date. Column one represents the month, Column two
represents the day, and column three represents a year. For example a birth
date (1) 05, (2) 15, (3) 1956. In the fourth column that I will create I
would like to place the function so that I can have similar results of
05/15/1956. I have played around, but I cannot get the numbers right, I am
still getting errors. Any help would be appreciated. Thanks so much.

Good point about the 05 Pete.


Gord

On Tue, 4 Nov 2008 23:12:21 -0000, "Pete_UK" wrote:

If you have 05 in column 1 (A) this suggests that it is a text value. So,
you might like to try this:

=DATE(C1*1,A1*1,B1*1)

Then format the cell in the style that you would like to see (custom -
mm/dd/yyyy)

Hope this helps.

Pete

"sweetthing4luc" wrote in message
...
I am looking how to create a function for the following. I have 3 columns
that represent a date. Column one represents the month, Column two
represents the day, and column three represents a year. For example a
birth
date (1) 05, (2) 15, (3) 1956. In the fourth column that I will create I
would like to place the function so that I can have similar results of
05/15/1956. I have played around, but I cannot get the numbers right, I
am
still getting errors. Any help would be appreciated. Thanks so much.

Well, I wasn't sure what the OP meant about "getting errors" - it
might be that the cell wasn't formatted as a date so s/he got a large
number and classed this as an error. Anyway, although it's belt &
braces to multiply by 1, it won't do any harm.

Thanks, Gord.

Pete

On Nov 5, 12:11*am, Gord Dibben <gorddibbATshawDOTca wrote:
Good point about the 05 Pete.

Gord



On Tue, 4 Nov 2008 23:12:21 -0000, "Pete_UK" wrote:
If you have 05 in column 1 (A) this suggests that it is a text value. So,
you might like to try this:

=DATE(C1*1,A1*1,B1*1)

Then format the cell in the style that you would like to see (custom -
mm/dd/yyyy)

Hope this helps.

Pete

"sweetthing4luc" wrote in message
...
I am looking how to create a function for the following. *I have 3 columns
that represent a date. *Column one represents the month, Column two
represents the day, and column three represents a year. *For example a
birth
date (1) 05, (2) 15, (3) 1956. *In the fourth column that I will create I
would like to place the function so that I can have similar results of
05/15/1956. *I have played around, but I cannot get the numbers right, I
am
still getting errors. *Any help would be appreciated. *Thanks so much.- Hide quoted text -

- Show quoted text -