Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|