Convert alpha-numeric code to date

Originally Posted by xladept

Hi Buchu,

Normal View:

3/28/2008	June 2012	50

Formula View:

39535	41061	=(K12-J12)*12/365

Does this work for you?

Hi,

Yes thats works thanks! I also discoverd the "DATEDIF" function

=DATEDIF(A1,A2,"m")

This function will subtract the two dates - you can have the result in days "d", months "m" or years "y". Try it out on your birthday to today's date to see how many months or days old you are. LOL!