birthday calculator

[viddz]

machnla Id no 1n bday cal karanne kohomada?

 

[Pink panther]

=IF(MID(A2,3,3)+0>500, "19" & LEFT(A2, 2) & "." & MONTH(MID(A2, 3, 3)-500) & "." & DAY(MID(A2, 3, 3)-500), "19" & LEFT(A2,2) & "." & MONTH(MID(A2, 3, 3)) & "." & DAY(MID(A2, 3, 3)))

oka exel eke paste karala paste karapu cell ekata wam patte cell eke ID no1 denna

 

[viddz]

oka exel eke paste karala paste karapu cell ekata wam patte cell eke ID no1 denna

machn thanks for the help ban. but i need the logic behind it. HR system 1ta ID no dammama auto bday cal wela fill wena widihata hada ganna ona ban ekai

 

[Pink panther]

machn thanks for the help ban. but i need the logic behind it. HR system 1ta ID no dammama auto bday cal wela fill wena widihata hada ganna ona ban ekai

ethin yako oka excel sheet eke lesiyenma karanna puluwanne bn...

 

[viddz]

excel newe ban java walin liya ganna logic 1i mata one

 

[Pink panther]

excel newe ban java walin liya ganna logic 1i mata one

ah, ehenam bump thama

 

[viddz]

ah, ehenam bump thama

thanks machn

 

[thilihare]

https://www.dropbox.com/sh/4s3oiilzdxhtcj3/68DIQ043CK

Machan podiyata kiwata fuluwan uparimayen hadala thiyenne okkoma ewwa Balanna

Read me doc 1 thiyanawa code 1
Java class 1
.java file 1 and podi image 1 kuth thinawa

 

[Neel Bandara]

bump.

 

[mfdo90]

Umba Deiyyek Bun

oka exel eke paste karala paste karapu cell ekata wam patte cell eke ID no1 denna

Umba Deiyeek bun mama meka excel walin hoya hoya hitiye... Thanks Machooo

 

[arunajn]

machnla Id no 1n bday cal karanne kohomada?

Eg: 833393225V

1st two digit 83 = 1983
next 3 digits 339= Number of days
So, 31+29+31+30+31+30+31+31+30+31+30 = 335 = 11 months
339-335 = 4 = B'day fallen in 12th Month

Therefore B'day is 1983 . December 04

If a girl above 3 digits always will be <500 so you have to deduct 500.
Eg 838393225v
839-500= 339. then same as above

 

[jnkdon]

noted.....!!!