Date Formatting

T

teeb

I'm trying to condense two columns of data into one clumn that has
date

In column A is a number between 1 and 365 respresenting the day an
month and in column B is a number (3 digits) that respresents the year
201 is 2001 and 198 is 1998.

How can I get these to show the correct date in 1 cell?

Cheers Tee
 
G

Guest

Hi

Try this:
=IF(B1>199,DATE(LEFT(B1,1)&"0"&RIGHT(B1,2),1,A1),DATE(LEFT(B1,1)&"9"&RIGHT(B1,2),1,A1))

Hope this helps.
Andy.
 
B

Bob Phillips

=DATE(B1+1800,1,A1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
G

Guest

Well, to be fair, yours is only about 40 characters less than mine, does not
includes an IF, or any LEFTs or RIGHTs. There's not much in it apart from
that!

Andy.
 
Top