march

Hello everybody. In importing data from an external agent, I have to deal with the following situation: https://imgur.com/a/oU9GE8j I have to use, preferably, the format dd/mm/yyyy. But the dates in the yellow cells are not correct, and they are not handleable in a usual way. I mean: they...

hi guys, I am new to VBA and I need help copying data from multiple worksheets to a single sheet in the same workbook. my workbook has 12 worksheets named by their moths. each worksheet has a number of rows that gets updated. please note that some fields of "Importer" are blank. for each...

Hello All, I will need help with below tables calculation... There are huge datas all the way down from column A. So if its possible I need to place formulas to get proper calculatin base on given table below starts from column J Many Thanks...

How would I use a Sumproduct to calculate V7, W7, X7 &Z7? (For April) I was able to use the Sumproduct for Jan, Feb, March, but am having trouble including April... <tbody> V W X Y Z Jan Feb Mar Q1 Apr 7...

Hello, I have a large table similar to the one below, with first column as ID numbers. I want to select any row based on the ID number and select only a range of data from that row. For example, I want to be able to select data for ID #3 from March to May, which would be 6. SUMIF didn't work...

I have a worksheet that looks similar to the below - the data-set is very large so I just need to be able to create a single formula to take the average of the first 4 values in that row. some at the beginning are blank - I want the formula to ignore blank and take the average of the first four...

Hello, I have 4 month: January, February, March and April in range A2:D2 January actually means 1; February - 2; march - 3 and April 4 I need a code, that converts month name to number and return number Lets say row 3: February, february, April, April = 12 (2+2+4+4) row 4: January, April...

Hello, Does anybody know how I can calculate the quantity of shares in a sheet where the specific date isn’t there? The question is: what the holding positions (quantity of shares) would be for the following dates: 15th March 2003 14th March 2004 These dates are not in the actual sheet. Is...

So I need to keep track of staff member's attendance, since we have a goal of 80% to meet for calendar year 2018. I have several workbooks, one for each staff member, since I have other goals I have to track. As a group, I want toadd up all their monthly attendance, for example: Attendance...

I tried searching for the answer, but the problem is that I don't even know how to phrase the question for a search. I receive a csv file with data broken out into different groups of rows and columns. I want to clean up all of the data into one table. I tried highlighting the examples below...

Dear I have a question to you. Im using SUMPRODUCT for some querry and its perfectli works if at criteria Im using onlu one paramiter for one comumn. But now I want to use two parameters for one of columns. Simple example below Month Turnover ……. Jan 1 Feb 2 March 3...

Hello everyone, I have a series of dates from 2013 till 2018. I'd like to count the exact days for them but they aren't in sequence. Meaning a date could start from 12 march 2013, the next one from 15...etc. <colgroup><col></colgroup><tbody> 08-Jan-13 09-Jan-13 12-Jan-13 15-Jan-13 Many...

So I have a pivot table and one column is years. Data starts with April 1, 2016 and goes through March 31, 2018. It has each month shown and then totals for each year. How can I replace those totals so that it shows per 12 month period instead? So instead of 2016, 2017 and 2018 totals. I...

Hi all! I need your help to calculate 9 Month periods gap between dates (months March, December, September and June in any order) Just like week/month/quarter/half year/year end. I need that for nine month period. For eg. If I find June-end date first from the date list then March should...

Hi, I need a formula that will return one of F2019, F2018 or F2017 depending on the columns of year and month. Our year end is March so F2019 will run from April, 2018 to March, 2019; F2018 was April, 2017 to March, 2018; and F2017 was from April, 2016 to March 2017. I was trying to use...

I want to modify the formula below and consider a date range Count cell number in column D from January 1,2017 – March 30 2017. Count blank cells in Column E from the cell number January 1, 2017 – March 30, 2017 in column D Count if cells in column E is greater then zero – Range is the...

Hi Everyone, Ok so I have a problem, I need to calculate last year year to date figure. I have the data set out in columns <colgroup><col><col></colgroup><tbody> March 2018 ,G April 2018 ,J May 2018, M June 2018 ,P July 2018 ,S August 2018 ,V September 2018, Y October 2018...

Hello Dear, i use the below formula to get the count number of the specific cells based on month which are exist on the E column, it works correctly but while it face any cell that contains formula without result it will be (#Value) please your help to avoid this and only consider the dates and...

Hello all, I have twelve tables on a sheet, one for each month. Additionally, I have one table at the top of the sheet that I want to use to make entries based on a drop down list. I'm trying to think of a way for the user to select the month from the drop down and it then updates the...

Hello, I want to write a formula for when I update a "Reference" Sheet the letter i type in refers to the columns For example February is column: A March is column : B So in the month of February I want the cells to reference column A, but in March I want it to reference Column B. The...