Hi
I need some help to figure out how to calculate a date based of a set of numbers.
I have a large table.
each row in the table represent a userprofile with name, adress and other information.
One cell contain a birth number, it is always formated YYMMDDXXXX (xxxx = national numbers for the birthnumber)
I want to print a date based on the 6 first numbers.
Example: the birth number is 801031XXXX
then i want a date 1980-10-31
I want this done in VBA code
I could use some kind of formula... but not sure how to do this with VBA.
I need some help to figure out how to calculate a date based of a set of numbers.
I have a large table.
each row in the table represent a userprofile with name, adress and other information.
One cell contain a birth number, it is always formated YYMMDDXXXX (xxxx = national numbers for the birthnumber)
I want to print a date based on the 6 first numbers.
Example: the birth number is 801031XXXX
then i want a date 1980-10-31
I want this done in VBA code
I could use some kind of formula... but not sure how to do this with VBA.