creating a date format entry from seperate integers

  • 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 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.
 
In d1 enter
=date(a1,b1,c1) << and format as date
where a1 = 1993
b1 = 11
c1 = 28
HTH
 
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 column from seperate data 3
Comparing dates 1
Supressing a #VALUE! error returned? 3
converting numbers to date format 4
create a single date column from seperate month, day and year colu 3
Funds allocation by Calendar Year 3
Code Optimization 0
Find Running Total Value or % at a given Target Date or vice versa 3

Back
Top