months

<tbody> Payment start Payment End Frequency Paid Date Amount Current Period Payment Start Current Period payment end 08/07/16 07/07/36 3 Months FDOP 250000 01/08/07 13/03/20 1 Month LDOP 77978 01/12/15 30/11/25 12 Month FDOP 200000 </tbody> Hello IF i have...

I am looking for a formula that evaluates start month for Project 1, determines it starts in November, determines number of months to complete and calculates number of transactions per month based off of those cells. Any help is much appreciated

hello please can someone help me. I am using Excel 2016 and in my pivot table, I tried to group my date rows (example 11/12/2018) into months or years. However when I click on 'Group Selection', it automatically assigns Group 1, rather than giving me options to sort into years and months. I...

Hi I have been given a sheet of ages and asked to calculate the average. However the ages are in decimals e.g. 10.04 = 10 years and 4 months, 11.11 = 11 years and 11 months. Any ideas how to calculate an accurate average in excel?

Hi, I've got a table with a unique ID and some text columns and some numbers for each month. <tbody> Unique ID Text 1 Text 2 Apr May Jun 567926 ABC zafads 5 5 5 704740 DE fadf 5 5 5 704765 DE aafds 5 5 5 506511 DE adfa 5 5 5 705258 DE adfa 5 5 5 705259 DE afd 5 5 5 705260 DE...

I currently have a formula telling me the the date in which an animal reaches 16 months in age or 30 months in age, depending on whether they are a "B" or an "ST". =IF(E3="B",EDATE(C3,16),IF(E3="ST",EDATE(C3,30))) Would it be possible to add a function that would display a dash "-" if the B...

I was looking for some help with a formula. I want to count the number of months between two dates and have them be separated by the year. I received a formula but all it did was count the months and put them in the last year column. The formula that I am using is below. It works in my...

I need help setting up a macro for a billing form I use for work. I need when I click a button, it recreates a copy of that same excel sheet, but I need the numbers from a certain column(sheet 2; column e13:E21) to slide over a column(to D13:D21) and also be added to the value thats in that...

So i'm having a little difficulty working out how to get an average formula to work in regards to days, months & years. I have a spreadsheet which will track employee absence and i would like to be able to see the average duration for absenteeism across all employees. See below for an example...

https://1drv.ms/x/s!AvjBsEPEq12ngUXYnGLP8pykEIRq?e=f3gY9X How do I make this pivot table show the dates instead of grouping automatically to year and months? I tried the Alt + D + P option, but doesn't work there as well.

https://1drv.ms/x/s!AvjBsEPEq12ngURD4J_Yxbfrn7OV?e=ln2Olm I have a sheet of data. I converted it to a table. Loaded it into Power Query, unpivoted the dates columns, and then created a pivot table. But I want to be able to choose the months in the pivot table, but I'm unable to do so. What do...

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...

Hello and thank you for reading my post. This is what I need to do: I have data for three months. I need to determine what data the remaining 9 months will have based on the first three months. For example, January I had 1 credit memo. February I had 1 credit memo. March I had 3 credit memos...

Hello I have 5 files. Each with 5 worksheets. For each file am trying to consolidate 5 work sheets into one file using Power Query - so I land up with 5 files that each have one worksheet. Worksheet names are AUG_DATA, SEP_DATA, OCT_DATA, NOV_DATA, DEC_DATA. I am trying to consolidate 5...

Hi, Column J shows the leasing period in months, when start date is entered (col. K), then the end date (col. L) is automatically calculated by this formula: =IF(AND(J4<>"";K4<>"");K4+DATE(0;J4;0);"") Please see URL for screenshow below. On the red marked rows, it does not add all months (see...

Good afternoon - I am attempting to create a spreadsheet that will have 4 different summation columns to it. The amount of columns between the four main will vary depending on the amount of tabs in the workbook. The four main columns will be summing information from the feeder columns that are...

Good afternoon - I am attempting to create a spreadsheet that will have 4 different summation columns to it. The amount of columns between the four main will vary depending on the amount of tabs in the workbook. The four main columns will be summing information from the feeder columns that are...

https://1drv.ms/x/s!AvjBsEPEq12ngT4paIVYB5-Ol3Y2?e=XitD7z Hi guys, I have monthly revenue data that I want to add (YTD figure) Need a formula whose output updates based on say if I choose YTD May. Then it should add months 1 to 5 for the year. How would you approach this solution?

I've been adding monthly tables to a YTD table/dashboard and when I tried to do it today i got the following message "Cannot complete operation, a table cannot overlap with a PivotTable report, query results, a table merged cells or an XML mapping." I have been doing this for months... what is...

I have a staffing worksheet that gives me FTEs by week which I need for staffing but I need to submit my FTEs by month for budgeting reasons. I can go through an do this by hand, averaging the weeks together but I am wondering if there is an easier/cleaner way to do this. <tbody> B C D E F G...