monthly

Hi I am trying to put together a simple cash book to run from month to month. Does anyone know what formulas I will need to put into columns J & K to calculate row 3 to 9. I have gotten so far but I am having trouble with rows 8 & 9. Thank you. <colgroup><col width="24" style="width: 18pt...

Please help! I have been trying to work this out for the last couple hours and I haven't figured it out. Here is a link to my Facebook and Twitter where you can see a screenshot of my Excel workbook. https://twitter.com/Love4Parrots...

Hello, First of all, my apologies if this has been already answered in the past... My problem: I have some sheets' names obtained by combining strings from two columns in a different sheet, separated by a space. So, based on the below example, my tabs' names could be: A Monthly D Monthly B...

Hi. I have a column of monthly total costs & a column of monthly total takings from a vending machine our social fund has. Can anyone suggest a formula that could predict the date of break even? Regards

OK lets see if I can give the relevant details or close enough to work ... I have a spreadsheet in which I sum information daily. On the row for day end there is a cell in which I enter a D. I also sum week ending, designated with "WE" in that cell. Also, Monthly designated by "M" and...

I'm using Office 365 Excel, with Windows 7 Enterprise. I have multiple workbooks, that all have 12 monthly worksheets, plus several other sheets. I want to make certain updates in a given workbook, based on the value entered in the InputBox -- 1 for the "DEC18" sheet only, and, 2 for all 12...

Hi, I've been tasked with creating a spreadsheet that shows a comparison of monthly mail receipts between 2017 and 2018. Those mail receipts are broken down into individual product codes, 44 rows in total. The master data has been recorded on weekly sheets, with each working day having it's...

Hello! In need of assistance to build functional tool to help sales agents track monthly commissions. The commission rate is applied to monthly sales and the rate increases as accumulated annual sales reach specified thresholds. I'm having trouble entering formulas in the "Monthly Incentive"...

hi all, i have this problem: The client want comapre monthly data.... The process: the client work with monthly data... and him not want have every monthly data on same workbook. but they need compare March 2017 with March 2018 (by sample) i think in save data in a text file.... (i dont want...

I have been trying to make a Monthly Alphalist of Payees depending on the Return period selected from the scrollable list on the MAP sheet especially the amount of tax and the tax withheld column. The INPUT sheet where the Tax base for wte and tax base for gov mpay will be listed in sequence...

Hello friends! I have this control of diesel supply where I have the forms that I launch the releases, well in the tab "CONSUMO" are released, I created a form called "FrmDadosPesq" but I have to open this form to consult all the monthly and annual releases, thank you who can help me I...

Hi, Greetings! I'm looking for some assistance with a formula where I can get the sum of “ODD”, for all days(ODD) in the cell GI5 and copy the same for rest of the Monthly Total “C&P”, “WAREHOUSE”, “PROCUREMENT”,”REMARKS” I have added all the “ODD” cells for that respective employee using SUM...

Hi All, I am trying to figure out a better way to get monthly totals for data imported from a Gantt chart into columns A to D. I added a hidden reference column that gets imported to column A in Excel. The table in the image below needs to show the monthly orders for: Australia which...

<colgroup><col span="2"></colgroup><tbody> Start of Cash Flow 7/1/2019 Monthly cash flow 5000 7/1/2019 5000 7/1/2019 5000 10/1/2019 5000 </tbody> The above is my table in Power Pivot, I also have a date table expanding out for the time period I need. I am currently using this formula to...

Hi Everyone, I am hoping someone can help me out on this one. I have a table similar to below, only larger. Headers are dates usually 6 months or so, but each column is a week. The rows are items. This table is on one worksheet. On a separate sheet I want to have a dynamic monthly total sheet...

In column a I have monthly data. In cell b1 I have quarterly values being the sum of the first three months in col a. I wish to copy cell b1 to cell b2 such that I get the sum of the second quarter of monthly data, i.e the cells a4 to a6 and so on. I need the function to copy down in cell b1...

Thanks to the IRS and how they publish data I am in need of an interesting Index Match or some such formula. The parameters are below; IRS Table - Single <TBODY> At Least But Less Than 1 2 3 4 5 6 7 8 9 10 305 0.0765 0.0765 0.0765 0.0765 0.0765 0.0765 0.0765 0.0765...

Hello All, I have the following formula below. If I am using 6 30 2018 as the end date, the range the following provides is YTD (Jan1 18' to June 30 18'). Now need calendar year however so should I be using EOMONTH ? Or something else. Data!$A:$A is a column of monthly dates. B2 = 6 30 2018...

Hi, Looking for an excel formula/coding, to get semi monthly paygroup for a particular date. For example, If I enter 07/23/2018(A1), the semimonthly date group should reflect 07/16/2018(B1) 07/31/2018(C1) Thank You,

I need to create a loan amortization schedule using Access. My challenge comes as we are using compound interest and I need to determine the monthly payments. I am able to get the total to be repaid using the formula: =[LoanAmount]*((1+[InterestRate]/[CompoundType)^([LoanTerm]*CompoundType))...