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.
Printable View
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.
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.
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.