year

Hello all I hope you can help on this formula, I want to try to compare day on day sales comparison over 2018 / 2019 At the moment I have a sumifs statement that just adds up for each month and a running total for the year, it's fine for this year as it will add up to today but last year...

HI every one, i need a small logic if any one can help it will be very great full to me. <tbody> Month 8 Year 2019 Calander Year 08.2019 09.2019 10.2019 11.2019 12.2019 01.2020 02.2020 03.2020 04.2020 05.2020 06.2020 07.2020 08.2020 09.2020...

I have a excel vehicle tracking system that uses log sheets entered by trip that has a date associated with each entry. This includes kilometers driven for that date and for what vehicle. I have the ability to change the year and month on a report tab that will produce the kilometers per vehicle...

Hi all, I have some coding that I have developed over time - but I'm stuck at one particular point. In 'column B' I have a list of dates, they are all in the same format (UK). What I want is some coding that deletes any row that has a date from the current year (I'll be using this code going...

Hi, I am trying to check a table/range for what the maximum change in percent is and to get the year, ex. 2019, in which the biggest change occurs in. I am tying to use MAX and MATCH formulas w/o success. In my dataset I have more years and more values but it seems fitting to post 3 values...

Hi all, I hope someone can help. I have a large XLS and I have a table of unit prices and then a separate sheet with costs by year. The problem is that each year is a single cell and the number of units increases by 10k each month. Is there a formula that will allow me to derive the yearly...

Hi, Below is a section of my working code. When it runs the year is entered into cell E7 I just need to add to the existing code that when the entered year is placed in E7 it needs to be Red. Maybe .Font.ColorIndex = 3 but where does it need to be added to the code below Please advise thanks...

Hello, I'm trying to make an excel sheet that tracks my bill payment dates. I need a formula that adds 5 years to the date 27/11/2012 and if that's < today() then add another 5 years and if that's < today() etc. etc. Right now I have 10 IFs just manually adding 5 years to each nested IF...

I feel like that's a weird subject but here's what I'm trying to do. I've analyzed year over year sales by customer and identified when a customer was new, if they were an existing customer but their total sales increased, decreased or stayed flat YoY, or if they were lost. (None would indicate...

Hi I have a spreadsheet which has many tabs at the bottom for different companies. Sheet1 is the master where all info is recorded on a daily basis, I run the macro and it copies the data to the relevant company tab, all that is ok. Now I have been asked that a new page is created with just the...

Hello, newbie here. can someone please help on how to work on the formula using dates (year... if possible movable dates) as basis for computing the interest. i made a formula and i cant seem find anyway to have the year be moving, depending on the present year, or if possible to include the...

If I could do this with VBA, I think I could figure itall out... but it's a shared work workbook and would really prefer to have itjust as a formula. Maybe I'm just over-thinking. I’m sorry I can’tupload a file example, the best I can do is a table in this thread. Here’s what I’m working with…...

I’m trying to accomplish the following: (my formula will bebased on a specific month, year, program name and look at a program descriptionto give me the year to date total.) I will have several lines with the same year, same program and same program description looking for the Year to date total...

Please help, I’m trying to accomplish the same result in this table with a formula when looking for thousands of data. Year Fruit Jan Feb March 2018 Banana. 1. 2. 3 2019 Banana 2. 3. 1 2018 Apple 4. 4. 4 2019 Apple. 2. 5. 3 Thanks

Hello all I hope you can help on this one Column "M" is a sales value Column "Z" has a Sales persons name in Column "H" date the date format "2018-01-19" Column "F" has the year Cell "D4" has the sales person's name in (Drop down Table) Cell "D7" has the Year" (Drop down Table) I have a...

Hi, I'm trying to come up with a formula that calculates how far we are through the year in percentage. Right now I have: =YEARFRAC(DATE(YEAR(TODAY()),1,1),TODAY()) But I'm not sure it's working properly. Any ideas? Thanks, Mark

I have a cell a1 with date say "07/31/2016", I need to populate cell b2 with a date that can calculate fiscal year, when the fiscal year is not same as calendar year. The fiscal year runs from 08/1/20xx to 07/31/20xx+1, For example: for date 07/15/2016 the fiscal year should end on 07/31/2016...

I have a table with columns for YEAR, CATEGORY (food, beverage, rental, misc, av, service charge), STATUS (actual, forecast, OTB), RMNOTB (a #) and REVENUE $. I also have a named range for BUDGET YEAR (budget_year). I need a formula to add the revenue amounts then divide by # of RMN OTB IF...

Hello All, Here is a question, I have a situation where i have a column "AD" that displays a date. The date listed should be 1 year from the date shown in column "AC", unless "N/A" is noted, then it should list the date for 1 year from column "AB". I really familiar with vba but i don't want to...

https://1drv.ms/x/s!AvjBsEPEq12ngTEmm7uG4pZsIFot?e=oA9EZo I have three tables of information. Each table has these columns: - Year - Vendor Number - Expenses How would you arrange the info to produce something like the 'output' sheet (shown in link).