# Calculating Age From Date Of Birth

Sep 16, 2009

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)????

## Calculating Age When Given Only Date Of Birth

Sep 6, 2005

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

"malvis" wrote:

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

## Calculating Individuals Exact Age Given Their Date Of Birth

Jan 21, 2004

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

## Converting Date Of Birth To 'Term Of Birth'

Feb 21, 2009

Is 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).

## Excel 2013 :: Calculating Count Of Persons Of Certain Ethnicity Relatively To Place Of Birth

Mar 16, 2014

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,>>

## Lookup Birth Date

Jul 25, 2009

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?

## Formula For Birth Date?

Jun 13, 2013

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.

## To Figure Date Of Birth

Aug 25, 2008

I 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?

## Using Reverse Date Of Birth To Determine Age

Dec 8, 2008

I'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.

## Count Of Names By Date Of Birth (DOB)

Jun 26, 2008

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

## Formula To Calculate Age Based On Date Of Birth

Dec 10, 2009

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.

## Dertime Current Age Based On Birth Date

Apr 21, 2008

I 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.

## Calulate Age: Find Out Over Aged Students By Date Of Birth

Oct 1, 2008

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.

## Highlight Chosen Age Based On Date Of Birth (DOB) Calculation

May 4, 2008

how 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"

## Highlighting Birthdays (inc Birth Year) Past Today's Date

Oct 7, 2007

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.

## Date Of Birth And Joining Date, In The Format "mm/dd/yyyyy"

May 24, 2007

I 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.

## Calculating Due Date From One Of Two Cells?

Mar 25, 2014

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

So now ....

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

## Calculating Max Date In A Range?

Oct 13, 2011

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.

## Calculating Future Day And Date

Nov 24, 2012

I think I may have over engineered this formula.

\$F\$40 = Cell with Event Date

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

## Calculating Date Of Payment?

May 2, 2014

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))

## Calculating The Date At The End Of Each Week

Apr 24, 2007

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?

## Formula For Calculating End Date

Oct 4, 2009

I 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)

## Calculating Friday Date

Aug 7, 2006

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.

## Sorting Dates Of Birth?

Nov 11, 2013

I 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?

## Sorting Year Of Birth Out

Dec 21, 2009

I 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)?

## Calculating Date After X Amount Of Days

Apr 11, 2014

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??

## Calculating Next Due Date For Rental Equipment?

Feb 15, 2014

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.

## Calculating Several Data Depending On Date

Jun 12, 2009

I 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?

## Calculating Date AND Time Differences

Mar 21, 2006

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.

## Calculating 10th Date From List

Sep 20, 2008

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.