date problem in excel:FORM SYSTEM

[arindamkol_1978]

dear all ,

PLS HELP ME SOON . IM FACING A PROBLEM IN DATE FORMAT . I GOT A DATA(500) FORM SYSTEM , THERE THE DATE FORMAT WAS 060606 THAT MEAN (06-JUN-06) . NOW I WANT TO CHANGE THAT FORMAT TO THIS FORMAT(DD-MMM-YY) BY USING 1 FUNCTION OF FORMULA.

ARINDAM

[Marcelo]

Hi,

try to use it

=date(20&right(a1,2),mid(a1,3,2),left(a1,2))

format as date dd-mmm-yy

hth
regards from Brazil
Marcelo

"arindamkol_1978" escreveu:

>
> dear all ,
>
> PLS HELP ME SOON . IM FACING A PROBLEM IN DATE FORMAT . I GOT A
> DATA(500) FORM SYSTEM , THERE THE DATE FORMAT WAS 060606 THAT MEAN
> (06-JUN-06) . NOW I WANT TO CHANGE THAT FORMAT TO THIS
> FORMAT(DD-MMM-YY) BY USING 1 FUNCTION OF FORMULA.
>
> ARINDAM
>
>
> --
> arindamkol_1978
> ------------------------------------------------------------------------
> arindamkol_1978's Profile: http://www.excelforum.com/member.php...o&userid=35861
> View this thread: http://www.excelforum.com/showthread...hreadid=560751
>
>

[Marcelo]

for years before 2000, exclude 20& on the formula

regards

"Marcelo" escreveu:

> Hi,
>
> try to use it
>
> =date(20&right(a1,2),mid(a1,3,2),left(a1,2))
>
> format as date dd-mmm-yy
>
> hth
> regards from Brazil
> Marcelo
>
> "arindamkol_1978" escreveu:
>
> >
> > dear all ,
> >
> > PLS HELP ME SOON . IM FACING A PROBLEM IN DATE FORMAT . I GOT A
> > DATA(500) FORM SYSTEM , THERE THE DATE FORMAT WAS 060606 THAT MEAN
> > (06-JUN-06) . NOW I WANT TO CHANGE THAT FORMAT TO THIS
> > FORMAT(DD-MMM-YY) BY USING 1 FUNCTION OF FORMULA.
> >
> > ARINDAM
> >
> >
> > --
> > arindamkol_1978
> > ------------------------------------------------------------------------
> > arindamkol_1978's Profile: http://www.excelforum.com/member.php...o&userid=35861
> > View this thread: http://www.excelforum.com/showthread...hreadid=560751
> >
> >

[arindamkol_1978]

dear all,

thanks for trying this. but it was not warking . it have some error if i used this
formula [ DATE(20&RIGHT(B2,2),MID(B2,3,2),LEFT(B2,2)) ] and put 060606 then I got the date as 05/12/2065 .
Pls help me .............. , i could not solved it still now.
arindam

[arindamkol_1978]

hi,
Im very sorry. 2morrow i send u a mail and told the function was not working , but at night i solved the problem . the function was correct . I was wrong.Thanks a lot . Bfore 2day i update the date field 1by1.Every day i have 2 update atlist 500 data. Now i doing that only one function.

I want to friendship with u , if u want then pls mail me in this e-id([email protected])

Thanks .