Hello, I’m having trouble with Libre configuring the formula using NETWORKDAYS as I need it to count only workdays and I need it to NOT count the date entered, it should start a day after.
With what I researched I got the formula
NETWORKDAY(A2+1, R2) and if both dates are the same it should be 0, but for some reason I get -2 and I cant work out why, does someone know how to check this?
I think your question has nothing to do with the Math formula editor (which is used to nicely format/layout mathematical formulas for inclusion in text document or presentations). It is likely you are trying to design some calculations for Calc. Please, retag your question by clicking on the “pencil” icon next to its title.
While at it, mention OS name, LO version and save format. This really helps to suggest an ad-hoc solution.
Changed tag.
If both dates in A2 and R2 are identical and you add 1 to A2 so the start date is later than the end date then you have 2 workdays counted backwards, that’s correct. If instead you added 1 to R2 =NETWORKDAYS(A2; R2+1) the result would be 2.
The result is 0 only if both start and end date fall on the same weekend.
A simplified form would be =NETWORKDAYS(A2;R2)-1 but that’s not quite right either if start date is not a workday. If such cases can occur, you’d have to compensate for that determining the weekday of the start date and either subtract 1 or 0.