month and year

Hello fellow colleagues, I have a task to calculate the number of months in a financial year (Australia) for grant payments that start in one year and end in the next, or in a few years. E.g. a $49,790.40 grant, which payments begins on the 16/10/2018 and ends on the 30/06/2019. The time span...

Hi All I'm trying to return the next 05 April from any given date, with the cell A11 holding the date. I was using this: =IF(MONTH(A11+1)=4,A11+1,DATE(YEAR(A11)+1,4,5)) Which works fine unless the date I'm using is a month less than 4 (eg jan,feb,march,April) as it will then return to me the 5...

Could someone please help me. I have a 2 columns one with a date and I want to put the month of the date in the other, see below 11/01/2020 I want the month and year of the date here ie. Jan 2020 12/02/2020 ie. Feb 2020 13/03/2020 Ie. Mar 2020 14/04/2020 ie. April 2020 Please help.

Hello Everyone, Is there a way to show a date as "MM-YYYY" format in power query or in DAX. The actual data is in "DD/MM/YYYY" format. Thanks in advance. Best Regards,

I have a table that I track deliverable in. In the table each deliverable is a column and I record the date it was received for each project. I was trying to create a pivot table where the rows were year/month, columns were the deliverable's and the body showed the count for each deliverable for...

Hello, I'm looking to get the count of the number of times a month within a year is listed in 2 tabs in excel. Column BU tab in Gone is the Months in the formula Column BV tab in Gone is the Years in the formula Column P in ISRs tab is the Months in the formula Column Q in ISRs tab is the...

I am having a problem with month and year in a chart. As you see, the month/year field is not in the correct order. https://plus.google.com/105279248984438843964/posts/i6qGXPFRHFG This is where the data comes from: https://plus.google.com/105279248984438843964/posts/6brz7dNWw5z The formula...

I have an IF statement that partially worked on another spreadsheet but isn't doing what it's supposed on my current one. If Application.WorksheetFunction.EoMonth(Date, -1) + 1 < Month(sh1.Cells(jRow, "H").Value) Then 'Deletes any Row that is Dates prior to current Month What...

As per attached file Can get experience in Years and months like "12 Years 10 months". <colgroup><col span="4"></colgroup><tbody> S No Name Date of Joining Experience 1 Kane 18-Nov-02 12.81 2 Morris 18-Nov-02 12.81 3 Bill 3-Feb-03 12.60 4 James 17-Mar-03 12.48 5 Rohit 15-Oct-03 11.90...

Hey guys, I was wondering if it were possible (with NO VBA) to have the month and year in two cells and in another 5 cells indicate the days in each week. There is room to have as many helper cells as necessary. Below find an example of the before and after: <tbody> A B C D 1 October...