age

Hello There I am looking for the simplest and shortest formula that will give " Working Age" (18yrs-aove) or " Old Age Pensioner Age" (65yrs Above) in a Colum. I already have Colum which states their age to workout if they are 18 or 65 years above. I am looking for the simplest shorts...

Hi all, I need to create a formula that will return the Name and the Favorite Color of a person according to the following: 1) Age = 17 2) Highest grade. <tbody> Name Age Grade Favorite Color John 17 99 Blue Stefan 26 99 Red Jake 17 78 Pink Donna 28 98 Green Sam 36 85 Blue...

Hello, I am trying to figure out where i went wrong in a VLOOKUP formula. I followed instructions exactly, but I still get the N/A error. Here is what i'm trying to do. I have 3 columns. Column A has the account number, Column B has the Name, Column C has the Age. I have a box where I want...

<colgroup><col><col></colgroup><tbody> single age Under 1 population 30,619 1 29,897 2 31,213 3 31,670 4 31,133 5 31,960 6 31,596 7...

Hi, i need a calculation in J2 formula which looks at the age of the employee in Column B and compare it with the Age of column F .when it finds matches in age then it Calculate in this way G2*C2 (8.31*2) and H2*D2(10.39*8) and I2*E2(11.22*2) in this case thanks <tbody> A Employee B Age C...

Hi guys I have been searching and searching and I can't get it working. I am using google forms and I would like to receive by email the answers as data. I.E. Column A will be Name, column B, age and column C city. So I would like to receive an email for everytime someone's answer and be...

Hi I have table like below, user will enter age and I want excel to return the name, so I did match/index function like this =INDEX(A2:D7,MATCH(G4,D2:D7,0),1) G4 = age Now if user enter G4 = 40 excel will return john, how can I ask excel to return linda as well. I am thinking it must be array...

Hi, I've been working on a formula for this for a while but haven't been able to crack it, any help appreciated. The data I have is peoples ages, and I want a formula to be able to take the age and automatically assign it to the correct age band. So I need to combine the following into one...

Hi, I used this formula for calculating the age =DATEDIF(K21,TODAY(),"Y") & " Years, " & DATEDIF(K21,TODAY(),"YM") & " Months, " & DATEDIF(K21,TODAY(),"MD") & " Days" Is there a formula to keep the cell blank if there is no data in the date of birth column?

Hi everyone, I need an efficient formula that I can copy to about 1000 rows. The formula calculates the chances of reaching 60 years old based on the person's current age, using the following table (1st column is age, 2nd column is probability): <30 20% 30-39 15% 40-44 10% 45-49...

I am working on a spreadsheet and I want to round the year for Voluntary Life Product. Basically, I want to take the birthdate and round it to a specific date so that the person doesn't age up until that specific date. For example. If the person is 59 a will turn 60 on their DOB of 5.9.19, but...

Hello to all, as I wrote in the title, I would like to enter a birth date in a cell and get the corresponding age back in the same cell, after I press return or another key. Thanks in advance for any help

Hi all, tell me how i can values in group wise below mention table. <colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody> Person Age majid 19 sajid 25 khalid 20 ahmed 60 nasir 35 khan 45 gulraz 31 </tbody>...

I have been sitting for hours trying to figure out the formula for one of the entries on my homework!! I NEED HELP BAD!!! What is the index-match formula to get the name of the consultant who knows all of the languages? Thanks in advance...

Is it possible in to make something in word that allows you to enter a date of birth and have it return the age? I was thinking a text box or something similar or being able to copy and paste some cells from a excel worksheet. But in that case, I need the slide bars and navigation bars to be...

Hi, can anyone help me with this please? I have several spreadsheets where I formula the age on year based on the date of an invoice and todays date. I then add a column and add a date range (manually) and work out a age range of 0-1 years, 1-2, 2-3, 3-4,4-5, 5+ So I currently add 2 columns...

=IFERROR(SUM(GETPIVOTDATA("Count of Age",Pivots!O$3,"Case Type",Cases!$B$4,"Age",{13,14,15,16,17})),0) In my current data set there is nobody age 16 and the formula returns 0 even though there are kids age 13, 14, etc. The formula works fine if I take 16 out of the condition array. But the next...

Hi I have a data set consisting of date of birth and date of death. I have calculated lifespan in days and have got mean and interquartile ranges from that. However, I would like to calculate lifespan based on months and separately years with the result being displayed in days - so I...

The formula below as well as other recommended methods yields the #VALUE ! error. see following note. Cells are formatted identical to the the formula that is noted to work. A 1/26/1875 B 7/21/1881 C #VALUE ! The formula the yields #VALUE ! is =ROUNDDOWN((E18-E19)/365.25,0) this...

Creating a retirement spreadsheet. I need to get the annual average of other income (2 columns) from retirement age through life expectancy. Of course the retirement age is variable depending on the client. I couldn't figure out how to attach a sample, so I'll attempt to describe it here...