Date Formatting

[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

 

[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.

 

[Bob Phillips]

=DATE(B1+1800,1,A1)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

Bob

You always have to go one better, don't you? <vbg>

Andy.

 

[Bob Phillips]

I just hate IFs Andy <ebg>

Bob

Bob

You always have to go one better, don't you? <vbg>

Andy.

 

[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.