how to count Unique date in range by formula only

[Nipendra.dhiman]

Hi All,

i am trying to count the unique date count from a range which is based on two criteria.

example sheet attached pls help or share you thoughts.

i have found the unique date count by the:- sumproduct(1/countif(Range,Criteria)

but if i have some name and week name also in terms of criteria how will i get the unique count.

Sample attached.

Regards
Nipendra

 

[Somendra Misra]

Hi Nipendra,

See your file.

Regards,

 

[Nipendra.dhiman]

thank u so much appreciated.