I am using the network days function to calculate the difference between two days.
I am using the formula.
=IF(J9="","",(NETWORKDAYS(J9, N9)-P9)-1)
J9 refers to the start of an audit day
N9 refers to the end of the audit day
P9 refers the the number of holidays in between.
Finally it subtracts one day so, such that the calculation starts the day after J9.
The formula should work such that if March 26th is the start date (J9), May 9th is the end date (N9), and there is 1 holiday in between (P9). Then the business days in between should be 30. However, excel is showing 31 days.
Does anyone know why this is occurring and how to fix it?