Assuming you input customer name into D2, this will give a count of how many
occurences of that name appear within 15 days of last entry:

=SUMPRODUCT(--(C2:C100=D2),--(B2:B100+15=MAX((C2:C100=D2)*(B2:B100))))-1


--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"nishkrish" wrote:

hi

i have a database where column b is date column c is customer name when i
input customer name in the system it should check if the same customer name
appears within 15 days of time from his last transaction.




--
Nisha P