|
Re: Returning Every friday value in a series of dates
Filling in the first values for each chart, formulas for finding Fridays like so:
EVERY FRIDAY
K4: 3/31/2006
K5: =K4+7
....or to limit to Fridays just on your data in column A:
=IF(K4="","",IF(AND(K4+7<=MAX(A:A),ISNUMBER(MATCH(K4+7,A:A,0))),K4+7,""))
LAST FRIDAY MONTHS
L4: 3/31/2006
L5: =DATE(YEAR(L4),MONTH(L4)+2,0)+MOD(-WEEKDAY(DATE(YEAR(L4),MONTH(L4)+2,0),2)-2,-7)
LAST FRIDAY QUARTERS
M4: 3/31/2006
M5: =DATE(YEAR(M4),MONTH(M4)+4,0)+MOD(-WEEKDAY(DATE(YEAR(M4),MONTH(M4)+4,0),2)-2,-7)
LAST FRIDAY YEARS
N4: 12/29/2006
N5: =DATE(YEAR(N4)+1,MONTH(N4)+1,0)+MOD(-WEEKDAY(DATE(YEAR(N4),MONTH(N4)+1,0),2)-3,-7)-IF(MOD(YEAR(N4),4)=3,1,0)
__________________
If you've been given good help, use the  icon to give reputation feedback, it is appreciated.
Always put your code between [code] and [/code] tags.
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
|