May 05 2022 02:41 AM
Hi @srouchheng
it's not clear to me what exactly you want to get. You want to see 1 if the date in column A is a Monday, 2 if it is a Tuesday...?
Or is it something else?
May 06 2022 07:33 AM
Thank you Martin, I would like the formula for the result as show above in " Result Work Day" but I need help for the formula and function?
May 06 2022 07:37 AM
May 11 2022 02:53 AM
Hi @srouchheng
yes, I understood that you want to get 2 fro Ken.
But I do not understand the rule behind it. Why is it 2 in your example?
If I understand the rule that you want to apply, then I can possibly provide the formula.
May 11 2022 03:23 AM
@srouchheng Not sure which Excel version you are on, but I believe it to be an older one. Perhaps you can create a pivot table (add to Data model) and do a "distinct count" of dates for each person. That will give you the numbers you seem to be needing.
Otherwise, Power Query could do something similar. Both options are demonstrated in the attached file.