date difference

[mina97]

i have the following data 

i want the to exclude friday and saturday also o want to exclude the start date and start counting from the next day
so want to show the date diff as 3 not 4 

please help and thank you  
i wrote in date the following 

workdays = 

var TBL_DATE=CALENDAR(sheet[start date],sheet{end date])
var TBL_FINALDATE= ADDCOLUMNS(TBL_DATE,"WorkingDate",IF(WEEKDAY([Date],2)>=6,0,1))
return
SUMX(TBL_FINALDATE,IF([WorkingDate]=1,1,0))​

this is how it looks now 

start date	end date	date diff
23-05-2023 10:07:11	28-05-2023 14:07:11	4

[ChiragGarg2512 · Accepted solution]

Currently, the dax expression is marking saturday and sunday as 0 rather than friday and saturday. For, friday and saturday change WEEKDAY([Date], 2) to WEEKDAY([Date], 1). This will mark friday as 6 and saturday as 7 instead of marking friday as 5, saturday as 6 and sunday as 7.

Also, if one day has to be removed every time remove 1 from the total sum.