Need help to solve the report by formula

[Sanjib85]

Hi Everyone,

I need help to make this report by Formula. I tried to make it but i can't do it by formula please help me.

Serial No. Audit Date Account Name Partner Name Campaign Name Campaign Type Call Type (General Audit / Lead Audit) Name of Prospect 1 29-Jun-16 ABCD TQL Lead Audit Prospect1 2 4-Jul-16 ABCD TQL Lead Audit Prospect2 3 12-Jul-16 ABCD TQL Lead Audit Prospect3 4 13-Jul-16 ABCD TQL Lead Audit Prospect4 5 14-Jul-16 ABCD TQL Lead Audit Prospect5 6 14-Jul-16 ABCD TQL Lead Audit Prospect6 7 15-Jul-16 ABCD TQL Lead Audit Prospect7 8 18-Jul-16 ABCD TQL Lead Audit Prospect8 9 18-Jul-16 ABCD TQL Lead Audit Prospect9 10 19-Jul-16 ABCD TQL Lead Audit Prospect10 11 19-Jul-16 ABCD TQL Lead Audit Prospect11 12 21-Jul-16 ABCD TQL Lead Audit Prospect12 13 21-Jul-16 ABCD TQL Lead Audit Prospect13 14 21-Jul-16 ABCD TQL Lead Audit Prospect14 15 22-Jul-16 ABCD TQL Lead Audit Prospect15 16 26-Jul-16 ABCD TQL Lead Audit Prospect16 17 27-Jul-16 ABCD TQL Lead Audit Prospect17 18 29-Jul-16 ABCD TQL Lead Audit Prospect18 19 8-Aug-16 ABCD TQL 20 8-Aug-16 ABCD TQL Lead Audit Prospect20 21 9-Aug-16 ABCD TQL Lead Audit Prospect21 22 11-Aug-16 ABCD TQL Lead Audit Prospect22 23 12-Aug-16 ABCD TQL Lead Audit Prospect23 24 17-Aug-16 ABCD TQL Lead Audit Prospect24 25 17-Aug-16 ABCD TQL Lead Audit Prospect25 26 18-Aug-16 ABCD TQL Lead Audit Prospect26 27 19-Aug-16 ABCD TQL Lead Audit Prospect27 28 22-Aug-16 ABCD TQL Lead Audit Prospect28 29 23-Aug-16 ABCD TQL Lead Audit Prospect29 30 24-Aug-16 ABCD TQL Lead Audit Prospect30 31 25-Aug-16 ABCD TQL 32 26-Aug-16 ABCD TQL Lead Audit Prospect32 33 31-Aug-16 ABCD TQL Lead Audit Prospect33 34 31-Aug-16 ABCD TQL Lead Audit Prospect34 35 1-Sep-16 ABCD TQL Lead Audit Prospect35 36 2-Sep-16 ABCD TQL Lead Audit Prospect36 37 6-Sep-16 ABCD TQL Lead Audit Prospect37 38 6-Sep-16 ABCD TQL Lead Audit Prospect38 39 9-Sep-16 ABCD TQL Lead Audit Prospect39 40 13-Sep-16 ABCD TQL 41 15-Sep-16 ABCD TQL 42 16-Sep-16 ABCD TQL Lead Audit Prospect42 43 16-Sep-16 ABCD TQL Lead Audit Prospect43 44 19-Sep-16 ABCD TQL Lead Audit Prospect44 45 19-Sep-16 ABCD TQL Lead Audit Prospect45 46 21-Sep-16 ABCD TQL Lead Audit Prospect46 47 22-Sep-16 ABCD TQL Lead Audit Prospect47 48 23-Sep-16 ABCD TQL Lead Audit Prospect48 49 26-Sep-16 ABCD TQL Lead Audit Prospect49 50 26-Sep-16 ABCD TQL Lead Audit Prospect50 51 27-Sep-16 ABCD TQL Lead Audit Prospect51 <colgroup><col><col><col><col><col><col span="2"><col></colgroup><tbody> </tbody>

<tbody>
</tbody>

Month No of Prospect June July August September <colgroup><col span="2"></colgroup><tbody> </tbody>

<tbody>
</tbody>

 

[Aladin Akyurek]

What is the question, i.e. formula for what?

 

[Sanjib85]

My question is How to count the number of prospect by month?

 

[Aladin Akyurek]

Does a prospect occur more than once in the same month? If it does, do we count every occurrence of it or just once?