Thread: How to calculate ages in Microsoft Excel

1. Member
Join Date
Jan 2012
Posts
55

How to calculate ages in Microsoft Excel

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.

2. Member
Join Date
Aug 2011
Posts
582

Re: How to calculate ages in Microsoft Excel

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.

3. Member
Join Date
Aug 2011
Posts
565

Re: How to calculate ages in Microsoft Excel

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.

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•