4 Replies Latest reply: Feb 15, 2012 4:05 AM by Maria Karlsson RSS

    Help with date and age

      Hi,

      Im struggling to find a way to convert a number to date and then date to age. I have numbers that look like YYMMDDXXXX where Id like to use the date and from that get the age of the person. So first off, how du I exclude the last 4 numbers and add "19" to the year? And then how do I calculate age today from the date?

       

      Pls help...