By Use of Datedif formula

  1. Write your date of birth in the cells. For example I will write my Date of birth in A column.
  1. Go to the cell in which you want your age to get displayed. Like I want to get my result displayed in C column against every input of Column A.
  1. Go to the cell and write the following formula
    “=DATEDIF(A2, NOW(),’y’)”

Apply the same step in all other cells to derive the result.

To Derive the Full age in terms on Years, Months and Days

  1. Write your date of birth in the cells. For example I will write my Date of birth in A column
  1. Go to the cell in which you want your age to get displayed. Like I want to get my result displayed in C column against every input of Column A.
  1. Go to the cell and write the following formula
    “=DATEDIF(A2,TODAY(),’Y’) & ‘ Years, ‘ & DATEDIF(A2,TODAY(),’YM’) & ‘ Months, ‘ & DATEDIF(A2,TODAY(),’MD’) & ‘ Days’ ”

Apply the same step in all other cells to derive the result

To Derive the Age in respect of same particular date

  1. Write your date of birth in the cells. For example I will write my Date of birth in A column
  1. Write the date in respect to what you want to calculate your age in the cells. For example I will write the date in B column.
  1. Go to the cell in which you want your age to get displayed. Like I want to get my result displayed in C column against every input of Column A.
  1. Go to the cell and write the following formula (I have written this formula in respect to position that Date of Birth is Mentioned in cell A2 and Date in respect to which Age is to be shown is mentioned in cell B2):
    “=DATEDIF(A2,B2,’Y’) & ‘ Years, ‘ & DATEDIF(A2,B2,’YM’) & ‘ Months, ‘ & DATEDIF(A2,B2,’MD’) & ‘ Days’ “
  1. To compute only age in respect of date given use the formula:
    “=DATEDIF(A2,B2,’Y’) & ‘ Years” ”

How do I calculate age from a specific date in Excel?

The simplest and most accurate formula to calculate age in Excel is =DATEDIF(birth_date,as_of_date,”y”). This returns the number of years rounded down.

How do I calculate age in mm/dd/yyyy in Excel?

Open Excel 2013. Type a birthdate into a cell in the format MM/DD/YYYY (if in the United States) or in the format DD/MM/YYYY if your country uses that format. Type =DATEDIF(XX, TODAY(), “Y”) then press Enter on your keyboard. Change the “XX” part of the formula to the cell containing the birthdate.

How do you calculate age from a date?

In some cultures, age is expressed by counting years with or without including the current year. For example, one person is twenty years old is the same as one person is in the twenty-first year of his/her life.

How do you calculate your age by hand?

Write down the current year and subtract the person’s year of birth. For example, if the current year is 2011, subtract 1952 from 2011. You can either do this by hand with a pencil and paper, in your head or use a calculator. In this example, you should get an answer of 59.

How do you determine your age?

Should I say my completed age or running age?

One year old. It means it’s been one year since you took birth. So If you completed 18 years that says it’s your Eighteenth(18th) birthday. Always express your age as the number of years that’s completed and not the next coming year.

How many seconds old is a 17 year old?

This conversion of 17 years to seconds has been calculated by multiplying 17 years by 31,536,000 and the result is 536,112,000 seconds.

How old will I be in 2040?

how old will you be in 2019, 2020, 2025, 2030, 2040 & 2050?

How Old Am I? – Age & Birthday Calculator.

How Old will I be?
Same Day on Age Day
2040 39 years 11 months 2 days Saturday
2050 49 years 11 months 2 days Thursday

How old is a 13 year old in days?

At 13 years old, you’ll be 4745 days old!

How old will I be in 2050 if I was born in 2009?

Your age will be 16 in 2025 if you born in July 2009.

How old will I be if I Born in 2009?

How old will I be if I was born in 2009?
Year Age
2040 30 years 11 months 29
2050 40 years 11 months 29

How old would you be if born in 2000?

If you were born in 2000, your age is 21 years now based on Gregorian calendar.

How old are u If your born in 1999?

You are 22 years old. Past and future: You were 21 years old in 2020.

How old are u If your born in 2001?

If you were born in 2001, your age is 20 years now based on Gregorian calendar.

How old are u If your born in 2003?

If you were born in 2003, your age is 18 years now based on Gregorian calendar.

How old would you be if born in 2005?

If you were born in 2005, your age is 16 years now based on Gregorian calendar.

How old are you if you are born in 2004?

If you were born in 2004, your age is 17 years now based on Gregorian calendar.

How old would you be if born in 2002?

If you were born in 2002, your age is 19 years now based on Gregorian calendar.

How old am I if I was born May 24 2002?

How old am I if I was born on May 24, 2002? – If you were born on May 24, 2002, you are 19 years old.