ExcelBanter - calculated form field

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - calculated form field (https://www.excelbanter.com/excel-programming/447399-calculated-form-field.html)

calculated form field

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?

calculated form field

On Wednesday, October 17, 2012 12:44:57 AM UTC-4, Crimsonk91 wrote:
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?

--

Crimsonk91

Here is a caluclation for age:
FIX(DateDiff("d", CDate(#04/01/1962#), NOw()) / 365.25)
Mike

Quote:

Originally Posted by Crimsonk91 (Post 1606423)

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