Convert excel formula into SQL Access or SQL Server

[sellal]

I need to convert the Excel formula into SQL Access or SQL server formula

First : The formula in column Duration is :
IF(AND(A2=A3;$E$1>=B3);B3-B2;SI(AND(A2=A3;$E$1<B3);"";IF(AND(A2<>A3;$E$1<=B2);"";$E$1-B2)))

E1 is : 31/05/2014

Num_ customer	Purchase_ day	Name_ Product	Duration	31/05/2014
957071417	22/04/2014	Product1
957074848	15/04/2014	Product1
958020505	21/04/2014	Product1
958022300	25/04/2014	Product1
958023030	30/04/2014	Product1
958630888	02/05/2014	Product2
958630888	03/05/2014	Product2
958630888	03/05/2014	Product2
958640915	01/05/2014	Product2
958640915	02/05/2014	Product2
958640915	03/05/2014	Product2
958644254	30/04/2014	Product2
958644440	03/05/2014	Product2
958646919	01/05/2014	Product2
958646919	02/05/2014	Product2
958678805	03/05/2014	Product2
958704045	07/04/2014	Product3
958704061	05/04/2014	Product3
958704061	25/04/2014	Product3

<tbody>
</tbody>

Second : The formula to calculate Average duration in the cell F4 is :
D is the column of Duration
AVERAGEIFS($D:$D;$D:$D;"<>""";$C:$C;$F4)

	Average Duration (days)
Product	To	To	To	To	To
31/05/2014	30/06/2014	31/07/2014	31/08/2014	06/09/2014
Product1
Product2
Product3

<tbody>
</tbody>

Thanks in advance

 

[Kyle123]

Which is exactly what the code I've given you does.

What is not at all clear is how you want to break this down into months - as I mentioned, you need to upload it to a file sharing site and post a link or do as you did before and just put the results directly into your post

 

[sellal]

I remember the data I pasted above.

 

[Kyle123]

Without you posting your desired output, I cannot help you.

I wish you the best of luck and hope someone else can

 

[Joe4]

You can post screen images using the tools mentioned here: http://www.mrexcel.com/forum/about-board/508133-attachments.html

You could also posts files up to a file sharing site and provide a link to it.

 

[sellal]

Be patient kyle123 I will find a way how to post the file see you

 

[sellal]

Hi Kyle123 and everybody ,

Here is the link for the Data : copy and paste it

https://onedrive.live.com/edit.aspx...relation=4958964c-5bf6-42eb-b8af-1505077bc876

Thanks for your help

 

[Kyle123]

One drive tells me I don't have permission to view it

 

[sellal]

Try this:

https://onedrive.live.com/redir?resid=8952ce5daef23b26!114&authkey=!AG_hg0pt48Huqlg&ithint=file,xlsx

 

[sellal]

I hope you could reach the table

 

[Kyle123]

I could, but the logic isn't clear - the formulas aren't consistent.

I'll have a look when I can set some time aside