mtd

Hi all, I am trying to get the month to date calculation correct but I am struggling with the last part of it. In order to have prior months, there is no issue but when trying to compare MTD of this month (15/11/2021) with the one of previous year (15/11/2020), the MTD calculation of previous...

Hi I am not able to change active sheet based on 3 criteria, I have done with first 2 criteria but third one is not able do do. 1- change tab name according the active workbook 2 should be add MTD in Sheet name 3- Add Month name (MMM) based on next sheet cell value. Example:- my file name is...

Dear Forum, I have a report where I need to show the Sales Performance in the MTD as well as YTD format. MTD- Month TO Date and YTD- Year To Date Numbers in the same report. I have a certain number of Files for a period beginning from 1-Jan-17 till 31-Mar-19. In India we refer the business from...

Trying to delete any rows that have a date prior to the 1st day of the current month. When I debug.print my variable MTD it gives the date 8/1/2018, but then when I filter and delete rows it goes haywire. Any advice? Sub MTDapps() With Sheets("Table") Rows.Sort Range("J2")...

Hi, I am looking to copy values from a specific range in a closed workbook/worksheet into a specific worksheet in the main workbook. The closed workbook is not in the same folder path. I am looking for the user to select the file. The workbook name that has the values is named MTD with...

I am new in VBA & start to learn it. I have Workbook name Primary Flash (MTD & YTD) and this Workbook have 6 Sheets and in all sheets, there are North, West, East & South Zone Data in Field (Region) I need to filter data from every sheets from Zone wise & paste in Anther Workbooks where same 6...

Hi there, is there an quicker method to perform the following on 'ActiveSheet"? Thank You For Each cell In ActiveSheet.Range("h2:h" & lr) cell.Formula = Replace(cell.Formula, "ACA", "ACA/52") cell.Formula = Replace(cell.Formula, "ACB", "ACB/18") cell.Formula = Replace(cell.Formula, "ACG"...

Hello, I'm trying to build a formula that sums up the YTD budget using an account and a date. I got the MTD budget using the following: =INDEX(A1:G4,MATCH(A7,A1:A4,0),MATCH(A6,A1:G1,0)) How do I sum the January through May amounts using 2 variables? <tbody> 1/31/18 2/28/18 3/31/18...

Hello, I am attempting to calculate the YTD, MTD, CYTD and revenue to date for a very large data set which spans the past three years. I have included a small sample below and welcome suggestions on the best way to achieve this. Kind regards, Esther <tbody> Year Month Banker Segment Product...

Hi I have the formula below that tells me what the current month is. I use it in slicers and filters. What I would like is a dax formula for MTD. IE on the 28th of the month I would need all sales from 1-28. I would like to use a slicer or filter for it. Maybe "CURRENT MTD"...

Hey Everyone! I could use some assistance in getting past a wall I've come upon. I'm needing to calculate the MAX value of a column after scrubbing the top 10% & bottom 10% from a separate staffed column using a Percentile formula. These two Formulas are pulling the Top & Bottom Staffed...

Hello, Could anyone help me. I'm not very good at Excel and need the formula's for the following. My target for the month needs to be split by the number of workings days and then the MTD figure worked out depending on date input. I will enter the Income figure daily but I need everything else...

Hi, Can anyone tell how to calculate current month data based on following table I need to display MTD figure for the month of July and when September comes up and I paste data then it automatically show September data in MTD column Excel 2010ABC1Sales ManMTDYTD2A3B4CSheet1

Hi I'm looking to sum week to date sales. And MTD sales year over year. I have to data in power pivot and have created a pivot table. So I'm fine with creating an excel formula to get the results. Or if needed using a DAX function. My data starts at B4 with the date 05/01/17 B C...

Hi, I'm using the following SUMIFS formula to calculate a running MTD figure from data in column B based on dates in column J and names in column I: =SUMIFS('RawRevenueData-(Nov)'!B:B,'RawRevenueData-(Nov)'!J:J,">="&DATE(YEAR(TODAY()),MONTH(TODAY()),1),'RawRevenueData-(Nov)'!I:I,"Federal...

As stated in a previous thread I am creating a KPI dashboard for my company. In this dashboard there are 24 data sheets that connect to the dashboard that can be viewed by the week of MTD or YTD. One of the data sheets is for a client count which is a running total. Which obviously doesn't work...

I am trying to figure out how to write a formula that will allow me to report LY MTD sales. The problem is that I have the entire drop of data for all of 2012 already dumped into the LY sales tab. I tried doing a sumifs function (as there are multiple attributes to be met in order to the get the...

My month to date budget number is a calculation of DAILY BUDGET X Days COMPLETED in the month. ( January has 22 working days) Daily budget = 60,000 (Static Number derived from a separate calculation) X Days Completed (5) ____________________ MTD Budget of 300,000 Tomorrow the formula would...

Hello dear forum members, I was wondering if there's a way to calculate what % of the month has passed thus far. For instance, if August has 31 days and today is the 26th, 83% of the month has passed already. Any ideas? Thank you in advance :)

I work in a call center and my agents are graded multiple times per month on 13 different categories. Two of them are Opening and Closing. Values Row Labels Sum of Opening % Sum of Closeing % 12/4/2011 100.00% 50.00% 12/5/2011 80.00% 40.00% Grand Total 88.89%...