Re: combining 3 columns into useable date

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx>
Date: Tue, 7 Mar 2006 17:52:49 -0000

=date(c2,b2,a2)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Rob B" <RobB@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C1B8405D-F85C-44C1-A7B0-95E1DE01B9C5@xxxxxxxxxxxxxxxx

I am cleaning excel sheets for import into another program which needs

dates

in one line eg 30/03/2006. Some of the worksheets I have contain date

fields

over three columns:

Day Month Year
06 03 2003
21 05 1987
14 05 1990
21 05 1987

I need to combine them & add formatting eg, From line 1: 06/03/2003

Have visibly lost hair trying to use CONCATENATE, can someone point to an
simple solution?

Prev by Date: Re: Work*** Names as a Date
Next by Date: Re: hash function for large strings
Previous by thread: Re: How do I get to the last line of a large spread*** to add data
Next by thread: Re: combining 3 columns into useable date
Index(es):
- Date
- Thread