age

I have a data set, say 3 columns with an infinite number of rows. For the first column I'll put in names, second would be left handed or right handed, then third would be age. Now I'd use 2 cells, first which will contain a value of a name as first criteria, and the other will contain a value...

I need to determine the age of a transaction from a historical standpoint. Normally I would use =TODAY()-A1 However, I have to produce historic data and when entering this formula, I'm getting the data as if it were today. Example: I have a payment date of 11/23/2018 and need to calculate...

Employee A , aged 62 is in a pension plan, the rules of which in 2015 were: Payout = 1/2 of Salary or 15000 whichever is less, in 2019, the rules changed payout = 1/2 of Salary or Social Security limit whichever is less but if Employee A is above the age of 62, the rule has always been payout =...

Okay, my brain is cramping but I'm pretty sure this problem I'm having can be solved by someone a lot brighter than I am. The two columns in question, columns B & C, need to work together for my worksheet to be accurate. They need to be able to account for users who are younger than 70...

This formula works 100% as intended which is fine when users are 69 years of age or younger. I have discovered that I need to modify it for those users who are 70+ years of age. =IF(personal_info!$E$12=0,"Estimated value of RRSP at 69 years of age","Estimated value of RRSP at end of "&...

Hello forum friends! Okay, this one is complicated (at least for me). However, I am hopeful that someone will be able to help me. There are three sheets involved and the formula in question resides on the ‘income analysis’ sheet in cell D97. The formula works fine for all intents and...

Column A is where I am tracking the last used row from. Column D contains the given dates Column BS will take the output data. Now this is what I want to achieve : I want to look at each cell in column D then if it is date, I find age difference with today's date then place that value into...

Hi All, When we have the data ready for Power BI, does it have any in house function we can group the one column of the data? For instance, I have one data set and one column is the age from 17 to 99 so Does Power BI can group them somehow or customized so we have three age groups...

Hello forum friends, would like to know if it's possible to convert a decimal to months of age. I have a formula that is returning "Started pension at 63.5222222222222 years of age" and I think it would look a lot better if it returned "63 years 6 months of age". The return does not need to...

Hi Guys, I'm new to excel and I took up a time sensitive assignment assignment and I really appreciate any help on this. <tbody> Start date (input) Eligible Months (input) Age 50 (Input) Age 55 (input) Rule62 (input) Age 62 (Input) Leave end date 06/1/2019 12.5 7/1/2014 07/1/2019 09/1/2019...

I am sure there is a simple answer to this question. I need to find the average age of people by their gender. I have used this formula and each time just get #NUM ! =AVERAGEIF(B2:B696,"F",C2:C696) Any help gratefully received

Hey all, I have a CSV file with the following data in rows: <tbody> {'gender': 'male', 'age': '35', 'hometown': 'Chicago', 'car': 'Civic', 'occupation': 'actor', 'salary': '80000'} {'gender': 'male', 'age': '32', 'hometown': 'New York', 'occupation': 'banker', 'salary': '130000'}...

Hi There, Please help! i have a table set out as follows, <colgroup><col><col><col><col><col><col></colgroup><tbody> A B C D E 1 Age of Debt Business Person Govt Other 2 Current 0% 0% 5% 0% 3 Up to 30 days overdue 10% 5% 5% 0% 4 31 - 60 days overdue 20% 5% 20% 0% 5 61 - 90 days...

Hi My code below removes duplicates to a new sheet, however I need it to do a bit more which I can not work out and have been stuck on for a few days. Command Button1 Dim Rng As Range, i As Long Application.ScreenUpdating = False Set Rng = Range("D1:D" & Range("D" &...

Hi All, How could i work out how many years between a job start date and now() a person was: - under the age of 22 - over 22 but under 41 - over 41 I've worked out the persons age from their DOB but my brain is frazzled trying to work the rest out!! Any help appreciated as always :) Dan

I am working on a sheet that will have columns Name 1, DOB 1, Age 1, Relationship 1, Name 2, DOB 2, Age 2..... up to 24 total. Info will be entered with a Userform.... and not every row will be filled with 24 people Form Uses the following code for each of the people 'Adult 1...

Hello, I've got a txt file with over 200+ entries that I want to convert into a table. How is it possible to have data formatted as the following: Name: Tom Age: 23 Name: Harry Age: 82 Into the following <tbody> Name: Age: Tom 23 Harry 82 </tbody> I tried data import but...

Hi I am struggling to get a countif / countifs formula to work for me. I need to count values in one column if they match a value in another column. Example below: <tbody> Age Mon Tues Wed Thurs 3 1 1 1 2 1 1 3 1 1 Total </tbody> So I need to know how many children age 2...

Hi, I have difficulties in created a stacked column chart with year and age group in x-axis in excel 2010. I would like to seek your advice on how to make a stacked column chart showing no of people of 2 different age group, e.g. below 60, and 60 or above in different year (2010, 2011...

Hi All, I am hoping someone can help me design a formula for my excel project. THANKS in advance! I am required to calculate the gestational age of a baby (in weeks and days) at a particular point in the pregnancy and also after birth. I have the date of birth of the baby and the gestational...