I am trying to add leaves other than specified in the image, but i am unable to add in the formula cell NJ8.
I am using W for indicating Work from Home, but i dont want to get these to be counted for Leaves this month COlumn (NJ) and Leaves This Year Column (NK).
Also Work From home can be appliable on any day of week.
I am using this formula in cell NJ8
=SUMPRODUCT((OFFSET($A8,0,31*($A$3-1)+1,1,31)<>"")*(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))))
I am using W for indicating Work from Home, but i dont want to get these to be counted for Leaves this month COlumn (NJ) and Leaves This Year Column (NK).
Also Work From home can be appliable on any day of week.
I am using this formula in cell NJ8
=SUMPRODUCT((OFFSET($A8,0,31*($A$3-1)+1,1,31)<>"")*(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))))
