Hello,
I want to make by power query a new column that does the difference between the dates but not taking into account the sundays.
thank you
[TABLE="width: 483"]
<colgroup><col span="4"><col><col><col></colgroup><tbody>[TR]
[TD]ORDER[/TD]
[TD]COMERCIAL[/TD]
[TD]Estado[/TD]
[TD]Canal[/TD]
[TD]START DATE[/TD]
[TD]FINISH DATE[/TD]
[TD]PRODUCT[/TD]
[/TR]
[TR]
[TD="align: right"]8366934[/TD]
[TD="align: right"]1[/TD]
[TD]Finalizada[/TD]
[TD]WEB[/TD]
[TD="align: right"]03/01/2017[/TD]
[TD="align: right"]21/01/2017[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]8370543[/TD]
[TD="align: right"]1[/TD]
[TD]Finalizada[/TD]
[TD]RETAIL[/TD]
[TD="align: right"]04/01/2017[/TD]
[TD="align: right"]07/01/2017[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]8370690[/TD]
[TD="align: right"]3[/TD]
[TD]Pte. Facturar[/TD]
[TD]RETAIL[/TD]
[TD="align: right"]04/01/2017[/TD]
[TD="align: right"]24/01/2017[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]8370699[/TD]
[TD="align: right"]4[/TD]
[TD]Finalizada[/TD]
[TD]RETAIL[/TD]
[TD="align: right"]04/01/2017[/TD]
[TD="align: right"]09/01/2017[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]8379311[/TD]
[TD="align: right"]43[/TD]
[TD]Pte. Validar[/TD]
[TD]WEB[/TD]
[TD="align: right"]05/01/2017[/TD]
[TD="align: right"]19/01/2017[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]8390201[/TD]
[TD="align: right"]1[/TD]
[TD]Finalizada[/TD]
[TD]WEB[/TD]
[TD="align: right"]10/01/2017[/TD]
[TD="align: right"]26/01/2017[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]8398311[/TD]
[TD="align: right"]4[/TD]
[TD]Anulada[/TD]
[TD]WEB[/TD]
[TD="align: right"]12/01/2017[/TD]
[TD="align: right"]17/01/2017[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]8398897[/TD]
[TD="align: right"]4[/TD]
[TD]Finalizada[/TD]
[TD]WEB[/TD]
[TD="align: right"]12/01/2017[/TD]
[TD="align: right"]26/01/2017[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]
I want to make by power query a new column that does the difference between the dates but not taking into account the sundays.
thank you
[TABLE="width: 483"]
<colgroup><col span="4"><col><col><col></colgroup><tbody>[TR]
[TD]ORDER[/TD]
[TD]COMERCIAL[/TD]
[TD]Estado[/TD]
[TD]Canal[/TD]
[TD]START DATE[/TD]
[TD]FINISH DATE[/TD]
[TD]PRODUCT[/TD]
[/TR]
[TR]
[TD="align: right"]8366934[/TD]
[TD="align: right"]1[/TD]
[TD]Finalizada[/TD]
[TD]WEB[/TD]
[TD="align: right"]03/01/2017[/TD]
[TD="align: right"]21/01/2017[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]8370543[/TD]
[TD="align: right"]1[/TD]
[TD]Finalizada[/TD]
[TD]RETAIL[/TD]
[TD="align: right"]04/01/2017[/TD]
[TD="align: right"]07/01/2017[/TD]
[TD="align: right"]13[/TD]
[/TR]
[TR]
[TD="align: right"]8370690[/TD]
[TD="align: right"]3[/TD]
[TD]Pte. Facturar[/TD]
[TD]RETAIL[/TD]
[TD="align: right"]04/01/2017[/TD]
[TD="align: right"]24/01/2017[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]8370699[/TD]
[TD="align: right"]4[/TD]
[TD]Finalizada[/TD]
[TD]RETAIL[/TD]
[TD="align: right"]04/01/2017[/TD]
[TD="align: right"]09/01/2017[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]8379311[/TD]
[TD="align: right"]43[/TD]
[TD]Pte. Validar[/TD]
[TD]WEB[/TD]
[TD="align: right"]05/01/2017[/TD]
[TD="align: right"]19/01/2017[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]8390201[/TD]
[TD="align: right"]1[/TD]
[TD]Finalizada[/TD]
[TD]WEB[/TD]
[TD="align: right"]10/01/2017[/TD]
[TD="align: right"]26/01/2017[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]8398311[/TD]
[TD="align: right"]4[/TD]
[TD]Anulada[/TD]
[TD]WEB[/TD]
[TD="align: right"]12/01/2017[/TD]
[TD="align: right"]17/01/2017[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]8398897[/TD]
[TD="align: right"]4[/TD]
[TD]Finalizada[/TD]
[TD]WEB[/TD]
[TD="align: right"]12/01/2017[/TD]
[TD="align: right"]26/01/2017[/TD]
[TD="align: right"]4[/TD]
[/TR]
</tbody>[/TABLE]