year

I've got a spreadsheet containing customer counts for each period of various years. As part of our periodic review process, we look at the year to date counts for a given period, compared to the same time frame for previous years. Currently, I adjust nine rows to include only the desired...

How can I extract the year "1851" from "AL011851" and copy that year for 14 rows. This process repeats with the variables being the year and the number of rows for that particular year. The number of rows to copy is given in a certain cell in column F. There are 52,000 rows in total. Example...

I have a pivot table that is showing sales for some rows as well as the % of total sales for those same rows. I do this for this year and last year time frames. I want to be able to have a calculated field that show what the point difference is between a row's this year percent of total...

Hi I want to understand datedif() function. What I do not understand the logic behind "Y", "YM", MD" Why YM to find month, why not only M? and why MD to find day? why not D same as Y for year. I do not understand the logic behind YM and MD? Thank you so much = datediff(A1,today(),"Y") - to...

Hi if I have date like 13/1/2001, I know i can use day(), month() and year() to separate day, year and month. I also know I can use text to columns. Which method has advantage/disadvantage over other. Thank you so much.

I need to calculate the year for the following data. What I want to know for the year column is if there is a date in the Visit date 2018 column bring back 2018 in the year column, if there is a date in the visit date 2019 it will bring back 2019 in the year column, if there is a date in both...

Hi- I have a spreadsheet (below) where I am trying to say Yes or No to whether or not a student met their goals. If a student's At Above/Below Grade Level (column B) is "At Above" and their Spring End RIT column C is equal to or greater than One Year Growth (column D) then the Met Growth Goals...

I have four columns with over 400,000 rows of data labelled (Year, Avg, UIC, Group) that look like (2013, 1.563, 0011, 23). I want to distribute them into 322 separate matrices, one for each Group that have columns labelled by the year: 2013 to 2019 and rows labelled by the UIC from 0001 to...

Hi All, I have a formula which has nearly 2yrs worth of data =WEEKNUM(TODAY()) issue i have is that means there are nearly 2 of every week. How can i determine in my formula to look at current year only? thanks Samuel

Hi, I have two data tables, one for 2017 and one for 2018. Next year I'll have another table for 2019. I am using named ranges for column names and I am using the named ranges in SUMIFS formula. However, since there are two different tables I can't figure out how to use SUMIFS to either...

Hello, Can anyone help me with a formula that counts invoice dates? Not sure if CountIF can do this or not Basically count how many items were invoiced in the current month and then another formula to count how many in the previous month Both for the current year. The formulas I am...

Attached is a set of sales data. The task is to produce a graph showing the total paid orders in GBP, with the months across the horizontal axis and sales volume (including postage) on the vertical axis. The graph should aim to compare year on year performance and I need a slicer to be able to...

So, I have a billing spreadsheet with a list of names in column E. I have pay columns that are based on years of experience. The names in Column E contain an * if they are first year and ** if they are 2nd year. What I want to do is change the background colors depending on * or **. I've...

I would like to format a cell with JUST this year, 2019, so that it automatically changes to 2020 next year, and subsequent years. Followed by cells that I would like to list as, the next years that changes also automatically. This Year...

Good Afternoon, I currently have a list of dates starting in cell A2 which lists every day of the current year (1/1 - 12/31). I also have some named ranges that reference columns A:U for each month (Ex: January is A2:U32, February is A33:U63 etc) . I'm running into an issue where since next...

I have a very involved Workbook which embodies many formulae. To ensure that each worksheet and process is not inadvertently corrupted I have initiate two strategies. The first was to construct macros which write formulae to workbooks, sometimes on demand but mostly when called by some other...

So I'm having trouble coming up with a formula to be able to count the number of months between two given dates and break it down by year. So if the dates are from (11/2018 until 8/2019) I would like it to break it down to 2 months for 2018 and 8 months for 2019. But I have a range of dates...

I have spreadsheets called allocation sheets. These are yearly documents and each row is a service instance. The row headings are: Date Purchase order # Req # Child Name Service Requesting Organisation Caseworker Name Price ex. GST GST Price inc. GST Allocated to Date report...

Hello, I am trying to create a tool which dependent on year, will tell me whether to upgrade a phone or repair. I have go to it work with the year so that it either returns "repair and Replace" dependent on year... but i want to incorporate an and statement in this. the statement below is...

i can't seem to get my head around this formula. i have a range of project data where each record has start, end, and change dates. Some of these records begin prior to the start of the financial year and some start within the financial year and then end after the end of the fin year. The change...