How can I subtract dates for finding working days in libre office?

[maxemilian1]

I need to subtract labour days (weekdays) between particular dates. So tried some but seems not efficient.

The dates are

08/16/23 and 08/26/23 (today())

=WEEKDAY($B$5) - WEEKDAY(H6)

result 01/02/00

another attempt

=NETWORKDAYS(H6,$B$5)

resulted as
01/07/00

Correct answer should be 8.
I need a simple number. How can I do this?

[Wanderer]

@maxemilian1

resulted as
01/07/00

@maxemilian1

Correct answer should be 8.

To explain this:
For historic reasons dates don’t “start” at 1 for Jan 1st 1900 but one day earlier, to compensate for a “forgotten” Feb, 29 in 1900. This can show, if a difference is formatted as date.

[maxemilian1]

Changing the cell format to number solves the problem. This fixes the result for the following formula.

=NETWORKDAYS(H6,$B$5)