Search results

I've attached a set of example data I'm using, ultimately I am trying to count the number of days an employee works in a week form the Work Shift Name column & the YH Days Worked column being the result I'm after

Hi, I have a col called Work Shift Name in a table which contains days of the week ie Mo, Tu, We, Th, Fr, Sa, Su. Im trying to count how many days a week an agent works, below is an example of the data & what I would like it to return Thanks K Work Shift Name No of days worked Mo, Tu, We...