months

How do I search a pre-defined pivot table with Month names as headers, then the pivot table has 2 values Cost and Quantity so when these are in the Values field in the Pivot table and I have let's say 4 months selected in the year, the first 4 columns will be Cost, the next 4 will be Quantity. I...

Dear MrExcel community Question How can I look up certain values in a table depending on a variable please? Background I have a table that is populated with numbers. The first column is a running date column, with each row being another day. I am looking for a formula that allows me to look...

Hi, I have some data that is represented in decimals. I want this data, in a different cell to be represented as months. For positive values it works fine, however for negatives it does not. My initial formula was as follows: =IF(AJ5="","",(IF(INT(AJ5),INT(AJ5)&" Years...

Hello, I have a Google Form which will be used to register animals for a spay & neuter clinic. One of the questions is "Age". I have multiple choices in Col A which include text. I want those choices to turn into numbers in Col B. I intend to report stats based on age groups in Col C. 1) Is...

Hello forum friends, would like to know if it's possible to convert a decimal to months of age. I have a formula that is returning "Started pension at 63.5222222222222 years of age" and I think it would look a lot better if it returned "63 years 6 months of age". The return does not need to...

I asked something similar to this a couple of months ago but I have a better idea of what I need. I have sheet that documents our companies new employees that receive a monthly draw (normally 5,000 USD for 3 months). My heard row includes a date column with the end of each month for a year...

I have a list of products. It is divided into 12 months. I know for a fact some products appear in more than one month. I want to find the values that appear in all 12 months. How do I do that? I understand how to find duplicate values across multiple sheets, but I don't know how to find...

Hi So I would like to work out a 3 month rolling average of data using an OFFSET function. The only issue is how can I amend my formula so that if I miss a month's data the cell is ignored an the previous month's data is used? The formula that I am using is...

I have a small table but I would like to know if there is a better way with a formula of doing this. I have a start value and 60 periods (5 years in months) at the end of the 60 months the initial value has reduced by 53% so how do I calculate the end value currently I am taking my start...

Hi All, I am working with a database that needs the rolling total of the last 3 months. For example, let say we are in June. One column will Sum the total of Mar, April, May. Another column for Feb, March, April. And the last one being Jan, Feb, March. I have figured out how to calculate the...

Hi I have an issue where I want to count complete months where all days count in the month. For example if you look at the difference between 2 dates, so 01/01/19 minus 01/01/19 we get 0, but say I want to say someone attended a course on that day, they in fact completed 1 day. So I want the...

Hi, each month I run a report and complete multiple Vlookups against last months report through VBA. The reports are called the same thing, example - April folder - Finance extract, May folder - Finance extract. In order for my macros to work, I have to each month rename the previous month...

please help im trying to find the date 3 months later, 6 months later, etc.....taking into account working/business days only ....i already have a table set up for holidays

Hi, I have attached a link to my workbook, sorry but I'm not able to attach files directly... https://drive.google.com/open?id=1E5SlHG28LuFo-SF7cKm1q-_18ba1EwU7 The data I'm graphing is on the 'Data' worksheet. There are multiple x axis rows that are blank in and this is making the chart...

if Cell A1 equals 53 months, I want B1 to equal 4 years 5 months.

Hello I am trying to set up a staff spreadsheet so I can track when the qualifications are due and I cant get my formulas right to change the cells. Our qualifications are renewable yearly so I would like the cells to change to yellow when they are due in 6 months orange when they are due in 3...

I am trying to insert a calculated into field my pivot table so that it gives me the average for the last 3 months in the last column. When I use the formula =AVERAGE(Last 3 months), it inserts a formula between each column, rather than giving me an average to the right. I'm sure there is a...

Greetings Excel Wizards. I'm trying to figure out how to make a SUMIF formula work based on the prior 3 months of the current month (excluding the current month). I have hundreds of parts with hundreds of shipments on my source data sheet (a shipping log). on a separate table I have a...

I am trying to work out a VBA Sub that will list out all the months between 2 given years. For example; year range is A1:B2 and the Sub would list out the values as shown in A3:B__ <colgroup><col span="2"></colgroup><tbody> A B 1 1940 2018 2 Year Month 3 1940 1 4 1940 2 5 1940 3...

So here I have a table which shows which months have 4 of a specific week day and which have 5. I am doing this because for my work I work with people who get X amount of hours of service per month. So for example if someone gets 12 hours of service per month and gets it for 3 hours every...