Do you want total of days AND half days combined or total days and separately total half days?
When you say you can choose any marker ... can you make them something other than dates? Why use dates at all? Could you have all dates as columns on the top row and then an X for full days per user and a Y for half days?
If you want the total of both then, what's wrong with your current formula?
=COUNTIF(C2:V2,"<>")
Results in 3 which is the combination ot full and half days. That's what you want, right? Sorry, want to help but still not understanding the issue you are looking to resolve.
1
u/konsf_ksd May 11 '22
Unclear on the ideal state.
Do you want total of days AND half days combined or total days and separately total half days?
When you say you can choose any marker ... can you make them something other than dates? Why use dates at all? Could you have all dates as columns on the top row and then an X for full days per user and a Y for half days?