View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John in Wembley John in Wembley is offline
external usenet poster
 
Posts: 26
Default Counting weekend shifts in a sheet



Hi team

I have a roster (they call it a rota here in the UK)

Row A: days along the top, monday to sunday for 28 days.

Row B,C,D staff members & their shifts along each row

How can I count at the end of each row how many saturday/sunday shifts
the staff member has done?
Is Dcounta the way to go?