years

So I am trying to create a formula to equally spread a given cost X starting at year Y and spread over Z amount of years. Ex <tbody> Cost X Start Year Y Spread over Z years 2019 2020 2021 2022 2023 2024 2025 1000 2020 5 0 200 200 200 200 200 0 </tbody>...

Dear all, Is there a way to: Calculate Cumulative interest paid at Month # 15 ("n") for Mortgage amortized for 25 years using ONE line. I want a single formula whereby I can just change "n" and it gives me the cumulative interest up to that point. All other mortgage elements (interest rate...

I have a spreadsheet with a column of dates (A) and anniversary dates (B). I want to make a column (C) with cells that calculate if the date in column B is equal to or greater than today's date. If so, I want them to subtract the date in column B1 from the date in A1 and put the number of years...

Hi everyone. I've got a column table reporting all the years the employee worked with our company. I would like to use it to filter some pivot tables so that they will return data pertaining to just one selected year, but unfortunately Excel won't let me choose singular years and will only...

Hi Excel Wizards, I've been trying to figure out a solution for the following problem. In one column, I have a series of dates that stretch back between 1 day to several years. I'm trying to come up with a formula that would highlight the cell as being red if the time is > 14 days, yellow if...

Hi, I am having trouble sorting out this data, I need to sort it out according to the table and the value in the table should be counted as number "1". In the first row, the column 4&5 was supposed to be merged but I can't do it here:confused: same with 6&7, 8&9.:biggrin: <tbody> DATA DATA DATA...

Can anyone help me correct the following formula: =IF(C2>100,IF(T2="Change of Ropa",ROUNDUP(VLOOKUP(DATE(2006,1,1),$Q$2:$R$28,2,0)*1.86,-1)+G2),IF(C2>100,IF(OR(T2={"Superannuation","Appointment","Annual Increment","Enhancement of Qualification","10 Years' Benefit","18 Years' Benefit","20 Years'...

<tbody> Start Date End Date Experience Job 1 04/04/89 09/30/97 8 years, 5 months, 26 days Job 2 06/16/97 06/27/97 11 days Job 3 07/07/97 06/24/16 18 years, 11 months, 17 days Job 5 06/27/16 01/03/19 2 years, 6 months, 6 days Total </tbody> I would like...

Trying to get excel to work out a formula for us, but I'm having a hard time setting it up. <tbody> Hire Date Journeyman Date Current % 11/1/2018 11/1/2020 ??? </tbody> Our new hires start out at 65% Journeyman waige, and over two years their wages will increase until they reach...

I have a column of dates (N) in date format (MM/DD/YYY), another column that counts total years worked (M), and a column with starting date (D) also in (MM/DD/YYY) format. I'm trying to get it so that when today's date is equal to or beyond the date in column N, the years worked (M) gets...

How can I convert 19 years 6 months into 19.5 years in excel? A1= 19 years 6 months, B1=19.5 years

How can I rewrite the duration ' <tbody> 19years7months1days' in excel in the format '19 years 7 months 1 days' using space. A1= <tbody> 19years7months1days B1= 19 years 7 months 1 days </tbody> </tbody>

How to round off 19 years 2 months to 19 years, 19 years 3 months 20 days to 19 years 3 months, 19 years 6 months 6 days to 19 years 6 moths and 19 years 9 days 20 days to 20 years in excel?

I have a spreadsheet which shows a list of locations against a number of years which show a percentage decrease across the years as shown below. Book1AEFGHIJKLMNOPQ2Station Name20182019202020212022202320242025202620272028202920303Acle...

I have this code that populates ten years before and 10 years after the current year, however I have various dates starting from column D15 that I would like to only show the range of years in the column. For example, If the first date is 03/02/2013 and the last date is 12/01/2018, I would...

Hi board members, I am sure someone can assist me please. I have a date i.e 08/01/2013 (dd/mm/yyyy format). In an adjacent cell I need to work out a date that is 6 years following the expiry of that current calendar year. So 08/01/2013, will show 31/12/2013 + 6 years = 31/12/2019 Many thanks...

Hello I am a software tester and I will soon be carrying out end to end testing which will cover a period of 6 years. Without the luxury of software tools I will utilise Excel. Currently my plan is to make every column a day (2192 columns), and every row a person (up to 500 people). Every...

Hi, I have a budget template that has IF statements to exclude costs bases on the max allowed ($25,000) and the previous years' totals. I have 4 groups of these per year for 6 years and all the IF statements appear to be set up the same and work in all but one of the groups and I can't figure...

I'm trying to make a formula that basically says if this number (4.57) is between B and C, then pull in A. Since there is more than 7 options, a regular IFTHAN statement won't work. I just can't think anymore and need help. <colgroup><col><col><col></colgroup><tbody> A B C 0 - 6 mo 0 0.5...

hey everyone! Having trouble wraping my head around a formula.. i have 3 tables; <colgroup><col><col><col><col><col><col><col><col span="6"><col><col span="6"></colgroup><tbody> Best Great Good 1 Year 3 - 6 Years 7 Years 1 Year 3 - 6 Years 7 Years 1 Year 3 - 6 Years 7 Years Quote...