Counting days help me pls

[FILIPKACZMAR]

Hello,

I need some help. I wrote the code:

counting without weekends =

VAR First = 'SQA list 2022'[End of Inspection]

VAR Last = 'SQA list 2022'[Delivered Report]

VAR First1 =

IF ( First <= Last, First, Last - 1 )

VAR Last1 =

IF ( First <= Last, Last, First1 )

RETURN

IF ( not isblank (first) && not isblank (last),

COUNTROWS (

FILTER (

ADDCOLUMNS ( CALENDAR ( First1, Last1 ), "Day of Week", WEEKDAY ( [Date], 2 ) ),

[Day of Week] <> 6

&& [Day of Week] <> 7

)

)

)

It is couting days from the End of Inspection Date, I want to count the days not from that day, but from next day. Can you help me?

Thank you 🙂

[johnt75]

Try

Working days = NETWORKDAYS('SQA list 2022'[End of Inspection] + 1, 'SQA list 2022'[Delivered Report]) 

[FILIPKACZMAR]

not working 😞

[johnt75]

you'll need to more specific. is it giving an error, what result is it giving ?