creating a date column from seperate data

  • Thread starter Thread starter T.O.
  • Start date Start date
T

T.O.

hi,
i have a very large table, in which the dates are represented by 3
seperate columns: year, month and day (all integers).
how can i use these 3 fields in a function (or macro) to create a
fourth column, containing the date in an excel date format?
i.e. if a line in my table looks like this: 1993 11 28
then i'd like to add a fourth column, reading: 11/28/1993

thanx.
 
Hi
Try entering in cell D1
=DATE(YEAR(A1),MONTH(B1),DAY(C1))
Copy down as appropriate.

Regards

Roger Govier
 
the functions YEAR(), MONTH() and DAY() require a serial number,
representing a whole date as input.
any other ideas? please??
 
My Apologies

I had meant to type just
=DATE(A1,B1,C1)
Format the cell in your desired date format

Regards

Roger Govier
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

creating a date format entry from seperate integers 1
How to get largest date from a Vlookup 1
Date Function Help 4
CALCULATE DAYS PER MONTH BETWEEN 2 DATES 2
create a single date column from seperate month, day and year colu 3
Excel date intervals look up 1
Data validation against seperate worksheet 1
Counting dates with specific criteria 1

Back
Top