Date - Date

[squalitooo]

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 ?

[Vinay_B · Accepted solution]

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

Working Hours Calculation excluding weekends and holidays

Let me know if this helps.

Thanks