year and month

Hi everyone, I am using microsoft Excel 2013 and I am having trouble with a formula I created to write the exact date based on the input from 3 other cells. I will now clarify: In cell J14 I have the ability to write the year (2015, 2016,2017, etc). In column G and H for example (G4 and H4) I...

Hi, I have value as below: <tbody> column A column L 03/04/2015 01/07/2013 03/04/2015 22/12/2014 03/04/2015 10/11/2014 03/04/2015 06/09/2013 03/04/2015 15/08/2014 </tbody> Now in column AA, I want to add flag "1" when, it have passed over 3 month between date from column A and...

Hi, I have simply for loop as below: Dim r_year, r_month As Date Dim i, rows_x As Long rows_x = ws.Cells(Rows.Count, "A").End(xlUp).Row For i = 2 To rows_x If ws.Range("A" & i).Value = looking_date Then r_year = Year(ws.Range("S" & i).Value)...

I have problem when using period time like this : 201301,201302 etc. But when i using formula in powerpivot such as : Sales Previous Month, Sales Month last Year, YTD, MAT. And then after i tried conversion from yymm (201301) to date time (01/01/2013) its works. See the file for the details...

I have some date ranges in column A i.e.06/04/50 - 05/05/50 and in column B a date in the following format dd/mm/yyyy. In Column C, I want to calculate the years and months from column B to the first date in column A. In Column D, I want to calculate the years and months from Column B to the...