create a date from year, day and month
 

I have an excel table that contains seperate rows with year, month and day of
a measurement as integer numbers - so for example the numbers 2004, 11, 13
would code Nov-13, 2004. Is there an easy way to create the date from the
year/month/day numbers?

Look in Help index for date functions

--
Don Guillett
SalesAid Software

"Baerbel" wrote in message
...
I have an excel table that contains seperate rows with year, month and day
of
a measurement as integer numbers - so for example the numbers 2004, 11, 13
would code Nov-13, 2004. Is there an easy way to create the date from the
year/month/day numbers?

Hi
=DATE(A1,A2,A3)
where
A1: Year
A2: Month
A3: Day

--
Regards
Frank Kabel
Frankfurt, Germany


Baerbel wrote:
I have an excel table that contains seperate rows with year, month
and day of a measurement as integer numbers - so for example the
numbers 2004, 11, 13 would code Nov-13, 2004. Is there an easy way to
create the date from the year/month/day numbers?

Vielen Dank :-)

"Frank Kabel" wrote:

Hi
=DATE(A1,A2,A3)
where
A1: Year
A2: Month
A3: Day

--
Regards
Frank Kabel
Frankfurt, Germany


Baerbel wrote:
I have an excel table that contains seperate rows with year, month
and day of a measurement as integer numbers - so for example the
numbers 2004, 11, 13 would code Nov-13, 2004. Is there an easy way to
create the date from the year/month/day numbers?