N
Neil Perry
Hello -
I am trying to calculate how many appointments that we planned to hold were
actually held within 4 weeks of the planned date.
For example, my input data is -
Col A Col B Col C
1. Planned Actual Within 4 weeks?
2. 01-Aug 01-Aug TRUE
3. 03-Aug 10-Aug TRUE
4. 05-Aug 03-Sep FALSE
5. 01-Sep 05-Sep TRUE
6. 05-Sep 10-Sep TRUE
Col C is calculated as =IF(B2<A2+28,TRUE,FALSE)
My Output Data is supposed to be
Col B Col C
Appointments
Actually Held Number Within 4 weeks
9. August 2 2
10. September 3 2
Column B =SUMPRODUCT(--(MONTH($B$2:$B$6)=8))
So far, so good.
I am not sure how I can count the number of appointment actually held within
4 weeks.
Does anyone have any suggestions or pointers?
Many thanks
Neil
I am trying to calculate how many appointments that we planned to hold were
actually held within 4 weeks of the planned date.
For example, my input data is -
Col A Col B Col C
1. Planned Actual Within 4 weeks?
2. 01-Aug 01-Aug TRUE
3. 03-Aug 10-Aug TRUE
4. 05-Aug 03-Sep FALSE
5. 01-Sep 05-Sep TRUE
6. 05-Sep 10-Sep TRUE
Col C is calculated as =IF(B2<A2+28,TRUE,FALSE)
My Output Data is supposed to be
Col B Col C
Appointments
Actually Held Number Within 4 weeks
9. August 2 2
10. September 3 2
Column B =SUMPRODUCT(--(MONTH($B$2:$B$6)=8))
So far, so good.
I am not sure how I can count the number of appointment actually held within
4 weeks.
Does anyone have any suggestions or pointers?
Many thanks
Neil