Excel Date of birth calculation from nic no

i want to calculate date of birth from that nic no, so this is the rules
the first two characters show their birth year,
the mid value(mid value means the 3rd, 4th and 5th character in that nic no) shows their date and month.
that means
january 31
february 29
march 31
april 30..........etc (going through our normal calender, only February has 29 days for calculation like leap year calculation)

eg:- some one born in 1995.03.15
then their first two character of nic no is 95 and the next three character calculate with their birth month and day, that means
1995.06.15
six months
january, february, march, april, may, june
31+29+31+30+31+15=136
now the first five nic no is 95136

if this is male 136 (nic no = 95136)

if this is female 136+500=636 (nic no = 95636)

that means if that date of birth is for female then we add 500 with our normal calculation,
so how to make a formula for this one in excel.
if we want to add more than one column tell me what to do..

also please help the other columns age and day of birth...


anyways thanks in advance..