I need help FORECAST formula

[bengal123]

Hi,

I have the below data, however I would like to predict the total deals in 01/01/2020,01/02/2020,01/03/2020 also I would like to predict how much revenue will be won on these months.

After that I need to calculate the conversion rate for Q4- 01/01/2020,01/02/2020,01/03/2020, it shouldn't be above then 100%

Product A Month Total Deals Won Deals
01/04/2019 Apr € 94,983 € 80,053
01/05/2019 May € 2,830,360 € 845,888
01/06/2019 Jun € 3,260,331 € 3,008,054
01/07/2019 Jul € 1,954,010 € 298,010
01/08/2019 Aug € 2,601,936 € 1,801,936
01/09/2019 Sep € 10,018,355 € 9,888,812
01/10/2019 Oct € 632,189 € 632,189
01/11/2019 Nov € 392,857 € 392,857
01/12/2019 Dec € 2,835,984 € 2,677,271
01/01/2020 Jan
01/02/2020 Feb
01/03/2020 Mar

[AliGW]

Welcome to the forum.

I have edited your thread title - I am afraid it is irrelevant to us whether your query is urgent or not. The forum is manned by volunteers who give of their time at no cost at all to you. You will get help as and when someone is ready and willing to give it. Until then, please be patient. Thanks for your understanding.