Feb 23 2022 12:54 AM
Hello people,
I am trying to calculate how many times until or after a deadline, using the =networkdays function to exclude weekends.
Example:
Today's date Deadline Days
Thursday the 17th of February Wednesday the 23th of February 4 days before deadline (or -4)
Wednesday the 23th of February Wednesday the 23th of February 0 days before deadline (or 0)
Friday the 25th of February Wednesday the 23th of February 2 days after deadline (or 2)
The unfornate thing is that =NETWORKDAYS includes today's day, meaning they return the values as -5, 1 and 2 in the above examples. A simple fix would be something like ''=NETWORKDAYS(A2; C2)-1''.
But the question is: How do I adjust the formula so that it adds ''1 day'' if the value returned is a negative number, and substract ''1 day'' if the value is returned as a positive number? I suppose it's with IF but I have no idea how to formulate the formula. Anybody can help?
Feb 23 2022 01:10 AM
SolutionFeb 23 2022 03:10 AM
Feb 23 2022 04:17 AM
That would be
=NETTO.WERKDAGEN(A2;B2)+POS.NEG(A2-B2)
Format the cell with the formula as General (Standaard)
Feb 23 2022 04:19 AM
@PAtesting Met dank aan @Hans Vogelaar voor de vertaling!
Feb 23 2022 01:10 AM
Solution