I need the age in years in Column T from data in Column K.
DOB (Col K) Age (Col T)
12 Jan 1978 ?
23 Mar 1966 ?
5 May 2001 ?
So the VBA macro must look up the DOB for each row of Column K and place the answer in Column T as age in years.
So the result must be:
DOB (Col K) Age (Col T)
12 Jan 1978 45
23 Mar 1966 56
5 May 2001 21
Many thanks
DOB (Col K) Age (Col T)
12 Jan 1978 ?
23 Mar 1966 ?
5 May 2001 ?
So the VBA macro must look up the DOB for each row of Column K and place the answer in Column T as age in years.
So the result must be:
DOB (Col K) Age (Col T)
12 Jan 1978 45
23 Mar 1966 56
5 May 2001 21
Many thanks