months

Hi guys, I am running a table to estimate the amount of sales I can generate. <tbody> Jan Feb Mar Apr May June Unit Sold in current month 10 12 14 16 18 20 Unit Sold from previous months X Unit Price ($) 4 4 4 4 4 4 </tbody> The 2nd row is where I am struggling. I am looking...

Hello Excel Gurus! I'm trying to find a simple formula to give me the currentquarter between two dates. I have to do quarterly performance evaluations on mypersonnel; however, the traditional fiscal year quarters work for works for thepersonnel I have that have been here since 10/1/2018. For the...

Excel 365 Insider (Monthly) v1903 build 11425.20204 All the dynamic array functions (filter, unique etc) are no longer available, and Excel says it is up to date! I have had them for months. Anyone else seeing this, or can suggest a way to get them back?

What is an easy way to calculate YTD sales for last year for the same months that have sales this year? In the example below, I want a formula that will determine that we are 4 months into this year, and only add the first 4 months of last year so that we have a YTD comparison. In this...

Hello all! I have some charts that I am populating from pivot tables. The data I am working with is sorted by fiscal year (FY) on the X, or horizontal axis. I see that excel lists the months chronologically, however (Jan-Dec from left to right), however I need the months on the chart to...

Good Day. Please help with the necessary formula. My employee gets 36 days sick leave over 36 months of work. But for the first 6 months he only get 1 day for every 26 days worked. on day 1 of the 7th month the rest of the 36 days "kick in"and needs to be added to the rest. HELP ! ...

Hi All. I am Interested to find out how my month I have paid each month from a set date with a set amount of monies each month. for example I need to pay 550 Euros each month into an account but I have paid more than that (6,050 Euros) more in total since the payment plan started. My...

Hi all. hope someone can help me with the issue i'm having in excel Example: I have a mortgage of 85,000 Euros, my Payment plan started on 01/09/2016 and will end on 30/06/2025, I have a monthly payment of 550 Euros per month. From 01/09/2016 up until end of April 2019 that's 32 months...

Hi all, I need your help in the below issue need: sum a production table based on months deposits. what I have: 1: sheet for each client with a table of deposits monthly based 2: all amounts in same rows of all sheets, but months are in different columns what I want: to sum months deposits...

Dear Team, I do not accurately know how to calculate months and days between two dates. I am not even sure what sort of assumptions that I should make. If I have these dates: StartDate EndDate 3/28/2017 3/1/2018 3/29/2017 3/1/2018 3/30/2017 3/1/2018 3/31/2017 3/1/2018 1/2/2019 9/25/2019...

Hi all, I need your help in the below issue need: sum a production table based on months deposits. what I have: 1: sheet for each client with a table of deposits monthly based 2: all amounts in same rows of all sheets, but months are in different columns what I want: to sum months deposits...

Hi All, Working on a way to look at total Sales (DEMAND) for a period in the future. In the case below it is the period starting 5 months from now for a total of 3 months of sales. Below is what I have. It seems ok to me but am getting an error that says "a table of multiple values was...

Hi all, I am trying to evaluate if a column on another sheet in the workbook’s date is less than 6 months ago and count them all up when the value (in this case it’s a person’s name) in one of the columns = the value I am looking for. I then what to split out the percentage of how often it was...

Hi all please can you help I'm trying to write a formula for the cells in yellow which counts the number of whole months in a calendar year based on the start date, e.g. start date 1st July 2019... there are 6 months in 2019 from start date. The numbers in there I've just manually worked out...

I have a Years of Service column calculating correctly, I also have another column that will populate each row with "10 YRS" "15 YRS" "20 YRS" and "25 YRS" if applicable by comparing 10years 0 months etc. A user wants the column to populate for the entire 12 months of the milestone anniversary...

Hi, I have a spreadsheet that has 2 rows and 24 columns (F15:AC16), 1 column per month for a 2 year period. Under the month row I have a balance row with a set of account balances. However, there is only a balance value under 12 months - not always the same months, but always sequential...

I'm trying to join the contents of two columns, and have the new string appear in a third. It looks great when I use Debug.Print, but I can't get the new string to appear in the third column. Here's my print statement, which works great: Debug.Print Worksheets("TEST").Range("AJ" & i).Value...

Hey all, I have a stock management .xlsm files for each month of the year 2019 These are named as follows in the folder named = Stock Share 01. January, 2019 02. February, 2019 03. March, 2019 04. April, 2019 05. May, 2019 06. June, 2019 07. July, 2019 08. August, 2019 09. September, 2019 10...

I have a formula I'm trying to modify without using VB... =IFERROR(LINEST(Output!D210:D245,Output!E210:O245,TRUE,TRUE),"") The idea is that D245 is the last row in a data set and D210 is the previous 36 months. Is this possible to make dynamic without VB? Any help would be greatly...