# Calculating Age When Given Only Date Of Birth

Sep 6, 2005http://www.cpearson.com/excel/datedif.htm

--

"malvis" wrote:

> Is there a formula that can calculate age when given only Date of Birth?

http://www.cpearson.com/excel/datedif.htm

--

"malvis" wrote:

> Is there a formula that can calculate age when given only Date of Birth?

ADVERTISEMENT

how to calculate the age from the date of birth and was given these two responses

1) I may be way off here but all that coding seems a waste !

I have in cell A1 = BLANK <--- enter your DOB here

I have in cell A2 =NOW()

in cell A3 do = A2-A1

Format that to General

In Cell A4 do =A3/365

Format that to no deciamal places and you get the age - this one is adding a year to everyones age?

2) Alternatively, if the DOB is A1 :-

=INT(YEARFRAC(A1,TODAY(),1)) - This one does not work it is saying there is an error with the "yearfrac"?

It is also when I am trying to put these into a pivot table, the pivot table is listing these down to 5 decimal places( when I have formatted to zero)????

I am looking for a formula that calculates an individuals exact age given their date of birth. That shows just the age in years.

View 9 Replies View RelatedIs it possible to convert a students DoB into their term of birth (ToB).

I.e. a student has the DoB of 1/1/2001 which would mean their ToB would be 'Spring'

I suppose what I'm after is...

If a DoB falls into one of three groups

1/1/year to 30/4/year = 'Spring'

1/5/year to 31/8/year = 'Summer'

1/9/year to 31/12/year = 'Autumn'

The year of birth is irrelevant, it's the month which determines the 'term of birth' (Spring/Summer/Autumn).

I am Using Excel 2013 on windows 8 OS,

I have no programming background but I have an Idea about it and I try to write some VBA Macros.

I have 27 Excel files which contain each of them 257368 Row Concerning personal information about persons

the File Format is as Follows:

Place of Birth (POB); Name; Father's Name; Family Name; ID Number; Ethnicity,>>

I have got a database wherein it contains the details like Employee Name, Birth Date, Date of Joining, etc in Sheet1. Suppose, Employee AAA birth date is 30/Jul/1980. When on 30th July 2009, it should display the Employee Id in Cell C3.

How should I lookup for the current date & month from the Employee Birth Date?

I am building a spreadsheet that has everyone's birth date on it. If the person is not 22 years of age or older I would like for the cell text containing their birth date to be highlighted in RED.

View 9 Replies View RelatedI have the date of death and the age at death in Years, Month, Days. What formula would I use to figure the date of birth?

View 9 Replies View RelatedI'm trying to use a list of date of births to determine an age output.

However the date of births are all in a simple reverse formate, eg

19790822 would be 22nd August 1979

Ideally, i would take this number and the output would just be the persons age in whole years.

I am using Office 2007 - Excel

I have a list of students with associated Schools

For each High School -Based on students Date of Birth (DOB) I am trying to get a count for:

Students UNDER 16 DOB before 8/25/91 and for each high school students over 16 DOB after 8/25/91

I thought subtototals, countif , maybe a pivot table to break down by school then do the 2 counts -

but I am at a loss for a formula to do the count

I have attached a sample file but the actual file has thousands of students and 23 different High schools which is why I was trying for subtotals or Pivot

I need a formula to calculate age today based on a person's date of birth. I used to know this but I have not used it for awhile.

View 4 Replies View RelatedI am using the following formula:

=DATEDIF(F7,TODAY(),"Y")

I have a about 1200 rows with a column of student's birth dates. I need to convert the dates to ages and have them inputted in the next column Ages. I ran the code in the 'Age' column and it worked for the first birth date. But I do not know how to copy the code to the rest of the rows so it will convert every birth date in each row.

I need to find out over aged students by date of birth - now()-age started to school: DOB 8/16/2000 , Now() Age started school is 8/30/2005. Student is in grade 1. should be age 6, however, he is 8. Answer should be a little over 2 yrs.

View 2 Replies View Relatedhow to make a cell to change color oatomatically accordant to Year and Month reflexted already in the cell. I have a spreadsheet with Names,Surnames,DOB and also a column that is given the AGE years months and days.

If somebody reaches 21 -1 -2 -3 months this should show different colors in the persons row in a particular column. The function used for the AGE is fund on ozgrid.com: =DATEDIF(H4,TODAY(),"y")&" years "&DATEDIF(H4,TODAY(),"ym")&" months "&DATEDIF(H4,TODAY(),"md")&" days"

I have a list of birthdays (in date-month-year format) and simply want to highlight them if the date and month are past today's date.

View 9 Replies View RelatedI have database of my entire staff with thr date of birth and joining date, in the format "mm/dd/yyyyy".

I want if the date of birth is equal to today()+1, that means if someone is having his b'day on 25may ,and today is 24 may so its cell colour should turn into red.

I know conditional formatting is to be used here. but bit confused with the formula.

I am trying with this

=IF(TEXT(C3,"dd-mmmm")=TODAY()+1,true,FALSE), but not working.

means I want if someones b'day is coming , I want to ge t informed earlier.

At the moment I have a simple formula that calculates the due date of a task

The log in date is in cell B3, I use a simple formula in cell F3 "=B3+20" - This gives me the due date

I now need to add another log in date but use the same due date cell

So now ....

Either B3 or D3 will contain a date - whichever one is populated I will need the due date displayed in cell F3

I have a need to calculate the latest and earliest date in a given range, but I cannot seem to make it work properly. The range looks like this:

Code:

23/08/201120/08/2011 13/08/11 13/08/11 13/08/11 13/08/11

and the code is:

Code:

d1ST = Application.WorksheetFunction.Max(rRow)

No matter the information in the range, the statement is returning "0" (or "12:00:00") - I have tried setting d1ST as a date and double data type.

I think I may have over engineered this formula.

$F$40 = Cell with Event Date

=IF(WEEKDAY($F$40,2)

I have a list of several hundred loan recipients who are all starting to pay their loans back on different dates. I am able to get the calculation to work so that I just need to put in the start date and excel works out the other 5 or 6 payment dates.The problem is, some people pay back on the 29th, 30th of the month which is giving me a headache when they are supposed to pay in February. The formula I am using calculates the next date of payment to be on the 3rd March (skipping the February payment all together).

The formula I am using is : =DATE(YEAR(A10),MONTH(A10)+1,DAY(A10))

I am trying to create a formula that returns the date on the friday (ie last working day) of whatever week I am currently in. So, for example, I guess I would use the 'TODAY' or 'NOW' function somewhere to determine the present date - but how do I then determine the date on the Friday of the current week?

View 9 Replies View RelatedI was trying to figure out how you could caluculate a project end date, based on a start date (dd,mmm,yyyy) and a project duration of lets say 5 work day and the work week is five days long (monday to friday). If i have a leave on the week days like tuesday is bank holiday then it should give be the date excluding that tuesday and wednesday leave and caluculate 5 working days and shoule give the project end date.

Example date: 5-Oct-09

Project end date:09-Oct-09

If i have bank leave on 06-Oct-09 means.

My project end date:12-Oct-09

Note:Bank holidays are fixed date example(every year bank holiday 06-oct-09,02-Dec-09,25-Dec-09)

Please dont need a macro.

I have dates listed in column A indicating the day an action was performed. In column B I need to have the date in column A changed to a Friday. If the date in column A is not a Friday, then the date in column B needs to fall back to the previous Friday. For example, if the date entered in column A is today, Monday August 7, then the date in column B that I would be Friday August 4. Can anyone think of code that determine this and place the value in column B? Currently I use vlookup to go to another sheet where all the possible dates are listed with their respective Fridays, but this slows down the calculation worksheet as the file is quite large.

View 9 Replies View RelatedI have a colmun of dates of birth, how do I sort them so that they are in order of the day and not by the year?

View 14 Replies View RelatedI have a list (starting with A2) with years of birth (as "1928" for born that year etc.), now - how can I (1) find out how old they are 2009? and (2) can I sort the ages out in three age groups (18-30; 31-55; 56-100)?

I am trying to determine a formula that will tell me what the date will be 61 days and 90 days from a selected date. For example:

A1: 04/11/2014

A2: (Date 61 days from date in A1)

A3: (Date 90 days from date in A1)

Is this possible??

I have a contract start date. The payment is due every seven days. I have entered the start date. i need the "next due date" to automatically calculate in the "due date column". here is my problem if a customer has a due date say on 2/15/2014 his next due date should be 2/22/2014. regardless if he pays on the 14th or 21st. i need this date to change each time a payment is made.

View 7 Replies View RelatedI have a truck log. Every time some comes in to take a truck they must log the truck out with the millage. After a week, I am supposed to find out how many miles my trucks ran for that week.

What would be the code to....

In K column, calculate the milage that is in row F; which is A3 - A2 and so on down. But it would have to skip a line every time the truck number changes (in column C) it would skip that line. It would go until a blank cell.

Does anyone have any ideas how to do that?

Within 4 columns, I have a series of:

Start Dates / Start Times / End Dates / End Times

I need to create a formula which will give me the sum total of the difference between the data sets.

For example, the time difference between 8am on the 20th March and 1pm on the 21st March is 29 hours OR 1 day and 5 hours.

I need a formula which will calculate this for me.

I'm using the following formula to find the 1st date that a particular rep wrote an order.

{=IF(S4="","",IF(MINA(IF('Daily Compliance'!$A$2:$A$5028=B4,'Daily Compliance'!$O$2:$O$5028))=0,"",MINA(IF('Daily Compliance'!$A$2:$A$5028=B4,'Daily Compliance'!$O$2:$O$5028))))}

I also need to figure out when they write their 10th order, but have had no success figuring that out.

Copyrights 2005-15 www.BigResource.com, All rights reserved