not sure how you came up with those
where does either of them go on your sheet? surely if no future months are used then you just need to count the no of x per person divided by the month of today
so =countif(d2:o2,"x")/month(today()) would give the % for wanda
i
Bookmarks