=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.