Results 1 to 3 of 3

Thread: How to calculate ages in Microsoft Excel

  1. #1
    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. #2
    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. #3
    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.

Similar Threads

  1. Need help to calculate Trend Growth in Microsoft Excel
    By New!life in forum MS Office Support
    Replies: 2
    Last Post: 21-02-2012, 01:22 PM
  2. How to calculate overtime in Microsoft Excel
    By Purujeet in forum MS Office Support
    Replies: 2
    Last Post: 15-02-2012, 07:11 PM
  3. How to calculate chronological age in Microsoft Excel
    By Mr.Pandhre in forum MS Office Support
    Replies: 4
    Last Post: 27-01-2012, 06:18 PM
  4. Replies: 4
    Last Post: 24-01-2012, 04:06 PM
  5. How to calculate Autocorrelation in Microsoft Excel
    By connoisseur in forum MS Office Support
    Replies: 4
    Last Post: 18-01-2012, 04:43 PM

Posting Permissions

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