year

Hi, I am trying to create a straight line Depreciation schedule forecast in Excel , based on the asset register received , for the purpose of Forecast , <colgroup><col><col><col><col><col></colgroup><tbody> Asset Current Cost Accumulated Depreciation Net Book Value Date Placed In Service...

2 columns, one date format xx/xx/xxxx and the other accounting format I'm looking to sum the value of the accounting column based on the current month and year. Preferably without having to add additional columns. I was following a previously used SUMPRODUCT formula but it kept giving me...

How do i create an if statement that looks at cell C6 and says if it is between 1/1 and whatever year and 3/31 whatever year that it returns 1st qtr or if it is between 4/1 and 6/30 then 2nd qtr and so forth?

Didn't quite know how to word the title... I keep a spreadsheet of music, albums that have come out every year going back to the 70's. As I listen, i score them. One sheet for each year, column A is the artist, B is the title, C is the score. I'd like to put a worksheet in front of all the...

Hello I have a list of dates and am trying to count the number of instances that are, for example, 3rd of May irrespective of year. Is that possible? I tried the following, with various permutations for the year but didn't work: =COUNTIF($A:$A,DATE(,5,3) Many thanks

Good Day :) I have to calculate the per day amount for a project and put it in a report showing it on an annual basis. My issue comes if the project starts mid of the month, i need a formula to determine the date from project start to year end and calculate per day rate. Eg: Project Start...

I have been using the following formula which works fine, but I would like to be able to change the Year part of the dates and wondered whether there is a way of referencing a cell value which would contain the year and therefore make it easier to change, I was thinking about the Indirect...

Hi Friend, I need help for filter all years date data and delete except current year Sheets("1_Clarity_REport").Range("E:E").AutoFilter Field:=5, Operator:=xlOr, _ Criteria1:="<=" & Application.Eoyear(Year, -1), Criteria2:=">" & Application.Eoyear(Year, 0)

Hello everyone, So im trying to do two sums of an expense report. The first one might be simple but i just cant figure it out which is adding all the values based on a specific year range. The second is the one I'm really stuck on which is summing the values a given name but now i would like...

I can seem to wrap my head around on how to put a formula together. Could someone provide assistance with a formula. Thank you kindly. "How do I annualized a return on an investment that has cash added or subtracted during the year?" (1) Total the beginning Account Balance and any...

I would like to add a formula to this cell (B53) to replace the two occurrences of the word "Dale". The cell currently contains approximately 822 characters. Excel limits the text within a formula to 255 characters. I understand that the CONCAT functions allows for putting text strings...

<tbody> Date Quarter FY Intended Results in column "C" 15-07-2018 1 1905 2018 10-09-2018 1 1905 2018 04-11-2018 2 1905 2018 14-03-2019 3 1905 2018 10-05-2019 4 1905 2018 20-12-2018 2 1905 2018 Detail...

I have the following formula =INDEX('[Sales Report2019.xlsm]Sales by month'!$A$11:$N$11,MATCH('[Sales Report2019.xlsm]Sales by month'!B1,'[Sales Report2019.xlsm]Sales by month'!$A$1:$M$1)) I have the year in Q1 I would like to use an ampersand to combine the year in the formula with the...

Hello, I have my first sheet 'Switchboard' that has this formula in Cell E1: =WEEKNUM(TODAY(),2) This yields '28' for the 28th week of the year. My worksheets are labeled Week 1, Week 2, etc. Since this is the 28th week of the year is there a way to jump to that worksheet (Week 28) ...

Hi everyone. Boring to count all the cells contain data. I have a worbook where marking my workdays and workhours. Once a year i have to calculate my workdays in SUM. In workbook have sure have for a year 12 worksheets. Any solution of formula for last month of year in separate cell ? Some...

HI Team, I need some help in data validation. I have years in column "A" like 2010,2011,2012,2013 so on ...and in column "B" I have quarters like Q1,Q2,Q3 so on....so, each year against quarters will be listed and not necessary every time 4 quarters some year should have 1 or 2 quarters as...

Hello, I need to write the VBA code make this easy. Range of A1:AN81 will put into or copy at the Range A+81. They are in the same folder. Thanks in advance. Please see the code below. Sub CopyPasteMultipleWorkbooks() Workbooks.Open Filename:= _ "G:\My Drive\2018-2019 SF1\Grade...

Hi all - I am trying to include a year over year $ difference in my pivot table but all the examples I see have the dates in a row field vs column. I want to just have one column after 2019 #s that calculates the difference from prior year. If I drag the amount field again in the values...

Hi All, I am not sure if you can help but I have a spreadsheet with a lot of sheets (countries) and within each sheet there is a table showing a rate card Year by year. <tbody> Year-1 Year-2 Year-3 Year-4 Year-5 Year-6 Daily Monthly Daily Monthly Daily Monthly Daily Monthly...

Hey guys, I have a bar chart with two values for a given year and this done over a 5 year period. For example blocks highlighted blue will be ascending over time with amounts increasing each year and orange will be decreasing each year Can the difference between the total summed values for...