"Ron Rosenfeld" wrote in message
...
On Sun, 1 Jan 2006 16:44:21 -0600, supersonicf111
<supersonicf111.20z9ky_1136155500.7119@excelforu m-nospam.com wrote:


I need some help with this one. Tried everything I can think of.

Thanks,

Brett

with 010105 in K1:

=DATE(1+MOD(K1,100),INT(K1/10^4),MOD(INT(K1/100),100))

That gives 1906. I guess you mean something like

=DATE(100*(MOD(K1,100)<70)+MOD(K1,100),INT(K1/10^4),MOD(INT(K1/100),100))