Quote Originally Posted by Bo_Ry View Post
B8 should be number 3.44 not 3,44

14 May is more than 15 Apr
I add D$4:D$23<H$2+29 to check date with in a month

=IF((C4="Urgent")*(D4>=H$2)*(D4<H$2+29),SUM(N(FREQUENCY(IF((C$4:C$23="Urgent")*(D$4:D$23>=$H$2)*(D$4:D$23<H$2+29)*(B$4:B$23>B4),B$4:B$23),B$4:B$23)>0))+1,"")
Damn I am so sorry .. i was fast on replying i should have checked.

You are a life savor. Your formula is what i was looking for. I am gonna do some trials on the formula with different scenarios and if there is any issue i would come back or else i would change the status of the post to "Solved".

Thanks everyone for your responses.