=SUMPRODUCT(--(Attendance!A6:A381<=Bob!A5),--(Attendance!A6:A381>=Bob!A5-6),--(Attendance!B6:B381=Attendance!$D$2))+(SUMPRODUCT(--(Attendance!A6:A381<=Bob!A5),--(Attendance!A6:A381>=Bob!A5-6),--(Attendance!B6:B381="?/Attendance!d2"))*0.5)+(SUMPRODUCT(--(Attendance!A6:A381<=Bob!A5),--(Attendance!A6:A381>=Bob!A5-6),--(Attendance!B6:B381="Attendance!d2/?")*0.5))
I am working with 2003 hence many limitations. This formula works except for "Attendance!d2/?" & "?/Attendance!d2" which returns no value. (This is where an employee has a half day such as A/P or S/A (Annual, Sick, Present) In D2 we have the "A.")
I know that "Attendance!d2/?" works in a countif, so I'm wondering if this is just a 2003 limitation or are you able to help with how this can be rectified.
Thanks kindly
I am working with 2003 hence many limitations. This formula works except for "Attendance!d2/?" & "?/Attendance!d2" which returns no value. (This is where an employee has a half day such as A/P or S/A (Annual, Sick, Present) In D2 we have the "A.")
I know that "Attendance!d2/?" works in a countif, so I'm wondering if this is just a 2003 limitation or are you able to help with how this can be rectified.
Thanks kindly