years

On November 21, 1998 I posted the first answer at MrExcel.com. A simple little formula of =A2-DAY(A2)+1 got this whole thing started. It is amazing that the community here has posted over 1 million threads in twenty years. We have a great knowledge base about Excel here and I love that I've had...

Hi there, Hoping someone might be able to help me with a Formula to calculate the funding availale for a Nurses Scholarship Fund Entitlement based on length of membership. I have a cell showing length of membership in years (say A1) and another cellshowing length of membership in days (say...

I have 4 reports that I get The data in these reports is simple, It contains one column with the customer code and a second column with an order entry date The 4 reports are Orders for the last two years Orders for the last Month Orders for the last 3 weeks Orders for the last two weeks I...

I need to find out the result of difference between multiple calendar data. For example I need to calculate in years, mont and days the sum of column C A1 B2 C3 01.08.1997 10.08.1999 2 years and 9 days...

Hello all, First time poster, I have a list of people that have different date of birth. I made a " template " page and a vba module to automaticly create a sheet based on the template for each person in the list. Now in the template page i need to figure out how to create 2 dynamic colomns...

Hi guys, In Column A there are lots of dates from different years, and in column B there are numbers that I have to sum. the problem is; I need to sum the numbers according to months and years. Are there any way to do that by using array formulas. I don't want to use the SUMIF function by...

Hi Everyone, I need some help in calculating QTD for mutilple years, months and dates, please see the table below. My actual sheet will have data from 2018 to future years by each month. And each month could have multiple dates in it, like shown in the sample data. I would like to display the...

Hello First post I know how to calculate the overall daily interest rate on a loan but what i would like to do if possible is to split this out into financial years So for example if a loan was taken out on 1 November 2018 and matured on 31 October 2021 (three years) I can calculate the...

Good afternoon, I'm trying to find out if I can set up a query to pull data based on two criteria on a single field. I have a table containing all the properties in the county and taxes owing back to the mid 90's. What I would like to do is query all the properties where they have taxes...

I am trying to add more columns to a worksheet that each column indicated a different year. I have years 1 through 5, but I want to be able to click a button and add more years continuing to as many as I want. Years 1 through 5 have formulas and I want to be able to bring those over as well. The...

Hi All I have a spreadsheet with dates in it that i would like to add either 1, 2 or 3 years to. There is a cell that lists if the customer bought a 1, 2 or 3 year licence so i need the formula to check that cell and then add the number of years. I started with this...

Hi, I want to calculate when a long service award is due 6 months in advance based of today's date for each category, hopefully by highlighting the cell with conditional formatting. This is my data: <tbody> A B C D E F 1 Today: 22-Oct-18 2 3 NAME START DATE LENGTH OF SERVICE...

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

rules: 60years + 10 years of experience OR 65 years and older. I have DOB in Column P and Hire date in Column Q, and I would like to have column R populate "yes" or "no' Can you please help. Thanks,

Hi I have various properties let out to various tenets . The tenancy are of various periods eg some may be 1 year or others may be 3 ,5, 10 years when date the rent increase may be yearly or every 2 or 4 years from the start of the contract. Is it possible to have an excel spreadsheet to...

Hi everyone, I have a full set of last years numbers that I am trying to compar to a set of this years numbers on a moving 4 week average. I can get the numbers for the current year using this array formula. =IFERROR(AVERAGE(INDEX('IWI Week Ending Usage Numbers'!3:3,LARGE(COLUMN('IWI Week...

Right clicking and choosing to unprotect a sheet, and entering the correct password (correct capitalization too) DOES NOT WORK. My macro that I have used for years to unlock this workbook DOES WORK. Using the same password. I have been using this workbook for 10 years and have never had this...

Hello, Could anyone please help, I have last years sales figures month by month and this years sales figures I would like a formula to compare sales percent increase or decreases per month and add a minus highlighting the percentage decrease Many Thanks for your help and advice Cheers