Excel Duty List -

i trying create duty roster class.

background: have weekday , weekend duties. people duties on weekdays 1 point, while on weekends 2.

problem: i'm wondering how code table in excel such whenever duty on weekday, recognizes person gets 1 point.

my roster such: (where a,b,c row references)

a name|points|date duty done on|date duty done on|date duty done on|

b name|points|date duty done on|date duty done on|date duty done on|

c name|points|date duty done on|date duty done on|date duty done on|

i've tried following code, checks if date weekday, , count cell if is:

{=sum(--(if(a:a<>", weekday(a:a)={2,3,4,5,6}))} 

for weekends, create separate column counts weekends, double points. in column called points, sum of weekday , weekend points.

unfortunately above formula doesn't work keep getting #na , #value errors , in end i'm unable roster done.

assuming have data shown in image below, where

• column a has names
• points should calculated in column b
• column c, d, e contains duty dates

enter following formula in cell b2 , drag/copy down required.

=sum(if(((weekday(c2:e2)=7)+(weekday(c2:e2)=1))>0,2,1)) 

this array formula comiit pressing ctrl+shift+enter.