Tema: Re: asmens kodas to gimimo data exelyje ?
Autorius: BlackLotus
Data: 2010-11-03 15:13:21
thanks
"Joint_as" <a@a.com> wrote in message 
news:iapgmo$lq3$1@trimpas.omnitel.net...
> formule:
> =IF(LEFT(A1;1)="3";19;IF(LEFT(A1;1)="4";19;IF(LEFT(A1;1)="5";20;IF(LEFT(A1;1)="6";20;"Blogas 
> a/k"))))&MID(A1;2;2)&"-"&MID(A1;4;2)&"-"&MID(A1;6;2)
>
> :)
>
>
> "BlackLotus" <besagun@gmail.com> wrote in message 
> news:iap92v$edf$1@trimpas.omnitel.net...
>> Sveiki,
>> kazkada zinojau formule kaip paversti asmens koda i gimimo data gal kas 
>> galetu priminti Exel 2003
>> Aciu
>>
>>
>>
>
>