Count distinct with set_expression

[Anonymous]

Hello,

I need to count the number of occurrences of a name within a week in a year

I tried something like that:

=COUNT( DISTINCT <WeekNumberOfTheYear> Name)

But it doesn't work.

Can anyone help me, please?

Thanks.

N.

[Anonymous]

Well, in the attached example, the technician 16997 is "overbooked" in the week 03/02/14, because he's contemporarly busy with the customer 1010000980 and the customer 1010001376.

I'd like to picture the background of the "overbooked" cell with another color, so that they are immediately visible.

Hope it's clear now.

Thank you.

N.

[Anonymous]

Any idea?

Thank you.

N.