how to calculate two dates difference considering Friday off.

[Anonymous]

i need to calculate datedifference between two dates considering friday off.  As i used formula for delay is

"" delay = DATEDIFF(Sheet1[forecasted finish],Sheet1[baseline Finish],DAY)   """

which is showing -149 day, is there any way i can make friday off and it will show numbers considering holiday

baseline Finish   forecasted finish     delay

20 June 2024

16 November 2024

-149

[FreemanZ · Accepted solution]

Hi @Anonymous ，

try like:

delay = 

VAR _gap = DATEDIFF(Sheet1[forecasted finish],Sheet1[baseline Finish],DAY)

VAR _fri = INT(DIVIDE(_gap, 7))

RETURN _gap - _fri