Excel Attendance leave tracker

1) I have downloaded this attacheded template. At present Work From Home (W) is listed as leave. But this should not affect on count of column (Leaves this month or Leaves this year). So i mean we should be able to notify in calender for Work for Home (W), but this should affect on the count.

Since the formula used in the cell will check whether the cell is noblank and counts, W is also included in the count. Hence the formula need to be changed so that W should not be added

In NJ8

=SUMPRODUCT((OFFSET($A8,0,31*($A$3-1)+1,1,31)<>"")*(OFFSET($A8,0,31*($A$3-1)+1,1,31)<>"W")*(IF(OFFSET($A8,0,31*($A$3-1)+1,1,31)=$NX$16,0.5,IF(OFFSET($A8,0,31*($A$3-1)+1,1,31)=$NX$17,0.5,1))*(OFFSET($A$4,0,31*($A$3-1)+1,1,31))))

in NK8

=SUMPRODUCT((OFFSET($A10,0,1,1,372)<>"")*(OFFSET($A10,0,1,1,372)<>"W")*(IF(OFFSET($A10,0,1,1,372)=$NX$16,0.5,IF(OFFSET($A10,0,1,1,372)=$NX$17,0.5,1))*(OFFSET($A$3,0,1,1,372))))