How to calculate ages in Microsoft Excel

[vALaNCiA]

Sponsored Links

I need to create a formula to calculate age as of 04-30-10. Can anyone help me. I am using Excel 2007. Are there any default formula for the same. I got a template for that, but that is not so functional.

[Go!pee]

You can use the following formula for the same. Type =DATEDIF(A1,B1,"y") with variable date in A1 and today's date in B1. There are other templates also that you can try out. Look in office help for the same.

[JyotiT]

You can use the <today's date> function for the same. Make that your "certain date". If the birth date is in A1, you can write: = INT ((TODAY ()-A1) / 365). The person will turn 29 until the eve of his birthday or = ROUND ((TODAY ()-A1) / 365; 0). The person turns 30 soon as it is closer to 30 than 29. With the birth date in A1 and the formula = TODAY () in A2, you will age in A3 with the formula = YEAR (A2)-YEAR (A1) with Standard.