S
scwilly
Hello this formula is from an earlier post can anyone help me figure ou
how to change this formula so that I don't have to use the first of th
month for my date range. If I change the date to say 1/2/2006 i
doesn't work.
A1: (the 1st of the month to start)
A2: (the 1st of the month AFTER the last month)
A3: (the occurrence to calculate…eg 3 for 3rd occurrence)
A4: (The day to find…eg MON for Monday)
C1: =SUMPRODUCT(--(MONTH(DATE(YEAR(A1),MONTH(A1)+ROW(A1:INDEX(A:A,D
TEDIF(A1,A2,"m"),1))-1,1+7*A3)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+ROW(A1:INDEX(A:A,
ATEDIF(A1,A2,"m"),1))-1,8-MATCH(A4,{"SUN","MON","TUE","WED","THU","FRI","SA
"},0))))=MONTH(DATE(YEAR(A1),MONTH(A1)+ROW(A1:IND
X(A:A,DATEDIF(A1,A2,"m"),1))-1,1)))
how to change this formula so that I don't have to use the first of th
month for my date range. If I change the date to say 1/2/2006 i
doesn't work.
A1: (the 1st of the month to start)
A2: (the 1st of the month AFTER the last month)
A3: (the occurrence to calculate…eg 3 for 3rd occurrence)
A4: (The day to find…eg MON for Monday)
C1: =SUMPRODUCT(--(MONTH(DATE(YEAR(A1),MONTH(A1)+ROW(A1:INDEX(A:A,D
TEDIF(A1,A2,"m"),1))-1,1+7*A3)-WEEKDAY(DATE(YEAR(A1),MONTH(A1)+ROW(A1:INDEX(A:A,
ATEDIF(A1,A2,"m"),1))-1,8-MATCH(A4,{"SUN","MON","TUE","WED","THU","FRI","SA
"},0))))=MONTH(DATE(YEAR(A1),MONTH(A1)+ROW(A1:IND
X(A:A,DATEDIF(A1,A2,"m"),1))-1,1)))