months

I need the leading 0 in the single months. I have 1/01/2019 and want it to be 01/01/2019.

Hi All, I am new to Excel so apologies if my question will miss pieces of information or is not clear. We work within the Construction Industry and make monthly projections of our turnover based on prospect. BACKGROUND We assume based on the size of the fee - which is related to the size of...

Hi, i have made a very simple linechart, with Months on the horisontal axis, but as data for the months august-december has not materialized, the line chart makes this annoying break at the last month with data (juli) , how do you make the line just stop at the last point of data? Kind regards...

Hi all, I have a workbook that's combining time off calendars for a couple departments with hyperlinks to hidden worksheets (months) for each department. This is what I have written on the Navigation tab Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) LinkTo =...

I've been stuck on this for about a week, I'll do my best to explain what I'm trying to do. I have column J with the following formula: =(((G2)+(F2/Q2))-(NETWORKDAYS(TODAY(), I2)/22)) I'm using this formula to tell, based on months of inventory on hand (G2), plus months on purchase order...

I have a graph of calls for each month. Jan to Dec Along the year, say in June, I'd have blanks for July to Dec. I'd like the graph to only show months with data, ie Jan to Jun. and not include empty space for the last 6 months. I've searched and found how to exclude blank dates between...

Hi all, this one has been getting on my nerves for a while now! Hopefully someone can help. I have some basic formula to work out the date 6 months after and nine months after column I. I also have some conditional formatting to turn columns J & L red if the date exceeds TODAY() which also...

Hi all, first time poster, long time lurker! I'm currently fighting with a dataset at work, where I need to show Jan-18 & Jan-19 data next to each other. However, no matter how I arrange my data set, the Jan-19 goes to the other side. Now, I get that it's following the sequential months/year...

Hi, I would like to show months 1 2 3 4 5....12 from column K to V in a pivot table, but the pivot is not sorting them from from 1 to 12 but keeps showing as 2 3 4 5 6 7 1 8 9 10 11 12. I can't get the 1 to go before 2 so in correct order. I've tried to drag the column to front of 2 but it...

Hi, I was looking for a formula to calculate Months and Days Until Next Birthday. I found this thread https://www.mrexcel.com/forum/excel-questions/355165-months-days-until-next-birthday.html It works well, unless the birthday month and day are the same as today. In that case (e.g. birthday...

I need assistance writing a code for identifying items not being sold within the last three months. The last sale dates are in column P,Q,R This is the last sale date at each of our three locations I need to identify which rows have not had a sale in the last 3 months and copy and paste all...

Hello forum, I have a question that I'm unable to correctly search for a solution since I'm unable to word it correctly for a search. Initially I had been looking at some kind of reverse CAGR solution, but what I found wasn't related to my problem. What I'm trying to do is take a Year End...

I have 3 pivot tables using same source data. I have month wise budget and actual numbers (3 columns - Month, Budget, Actual). I have created one slicer for month and only want to show months which have actual numbers(for example Jan to June). Right now, it is showing all the months as budget...

A bit of help for a 'novice' please - I am preparing a workbook that will track financials acrsoss 18 months for multiple workstreams. Currently only a couple of months have actuals the rest are still forecasts. Please see below... <colgroup><col><col><col span="6"></colgroup><tbody>...

Hi All, TL;DR: Need to figure out how to formulate the remaining sales dollars required based on how many selling months are left, based on what month it is, and put the remaining sales dollars required as an average line in a chart. - description I can get the average line on the chart no...

I am trying to compare Names + Course from 2 different months and having issues with Conditional Formatting Can someone advise me how to do this please. Looking to show which Names and Course are reported in Month 2 as well as Month 1 for the same Name and Course Thanks

hi all. i'm trying to work a reverse calculation on a finance repayment calculator. i have have the standard amortisation calcs.. $20k amount 84 months 10% interest $332 repayments per month Total interest component of $7890 If i bump the repayments up to $375 per month, it lowers the loan...

I am building a forecasting model that will allow for multiple ways to trend actuals data forward and I am looking for a formula to help me do that automatically where I don't have to adjust the formula every month. Below is the example data. I will have 2 full years of actuals up to the...

HI, I am sure this is a very quick question/answer, In one cell(D38) I have a SUMIFS formula, the answer it is returning is 0.415. This number is actually a calculation of months in decimals. In the next cell (E38) I have a vlookup to return this figure in months. Cell D38 is rounded to 2...

Hi I'm trying to work out the NPV of a simple repayment profile that has a stepped rental i.e X months at $100 followed by Y months at $1000 I can do this by creating lists but I want to develop a calculator where I can solve the NPV by having X & Y as variable numbers. I have other tools I...