Date Function Help

[sweetthing4luc]

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.

 

[Pete_UK]

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

 

[Gord Dibben]

=DATE(C1,A1,B1)

Syntax is Date(year,month,day)


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Good point about the 05 Pete.


Gord

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

 

[Pete_UK]

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