Date - Date

squalitooo — Thu, 07 Oct 2021 15:19:04 GMT

Hello,

i need to calculate delay between two dates working days.

data:

Date1 = 01/01/2021 | dimension1 | n°invoice
Date1 = 13/02/2021 | dimension2 | n°invoice

how to calculate delay, i have try this but not working :

variable :

vDate1=if(dimension1=1,Date1)

vDate2=if(dimension=2,Date1)

formule:

Avg({ <Date1={">=$(=Min(Date_Calendar))<=$(=Max(Date_Calendar))"}>} (networkdays (vDate1,vDate2)-1))

anyone can help me ?

Re: Date - Date

Vinay_B — Mon, 11 Oct 2021 04:30:42 GMT

Hi @squalitooo Have you checked this post which has a great solution to your question

Let me know if this helps.

Thanks