year formula

I really need some help on this one. I can't figure it out. :confused: I am trying to modify the formula below so that the cell references will calculate automatically depending on the current year. The problem is that the # of days in the 1st week changes depending on the year. This means that...

Hi, I have below table1 (sheet1): <tbody> <tbody> StartDate(A1) </tbody> <tbody> EndDate(B1) </tbody> Month(C1) Quater(D1) Year(E1) <tbody> 29/07/2012 </tbody> <tbody> 25/08/2012 </tbody> 1 Q1 <tbody> 2013 </tbody> <tbody> 26/08/2012 </tbody> <tbody> 22/09/2012...

I'm trying to us both sumifs and countifs to gather various information on a set of loans. I'm wanting to look at the year the loan was originated as one of my criteria in these statements, but the dates are stored with the actual date. I find that sumifs and countifs are generally MUCH...

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)...