Quote:
Originally Posted by Crimsonk91
I have a form in excel, in which one field a birth date is entered and in another field it calculates the age of the person, can someone please help me with this process?
|
Hi,
Is that all your form will do? If yes, I suggest use something in Excel which is less tedious to create. If I enter the DOB in cell A1 you can enter the following formula in cell B1 to see number of years, months and days the person is old from today.
=DATEDIF(A1,TODAY(),"y")&" Years "&DATEDIF(A1,TODAY(),"ym") & " Months and "& DATEDIF(A1,TODAY(),"md")& " Days."
If you want the same thing in the user form. Use the same technique (Datediff) and this should be helpful. Let me know if you have difficulty getting it on user form.
Thanks
Prashant