Workdays due and overdue

[Applemoose]

Hi,

I am looking to find a way to calculate the remaining workdays between 2 cells/dates and keep them counting when the date has past.

So the following:
A1: Start Date
B1: End date
C1: Either working days left or days overdue

Today is Feb 14th:

A1: 01-02-18
B1: 08-02-18
C1: -4

A1: 10-02-18
B1: 20-02-18
C1: 5

I think this should be a rather simple formula, but I just can't seem to make it work.
I hope someone can help me!

 

[Tetra201]

Maybe

=NETWORKDAYS(TODAY(),B1)+(TODAY()>B1)

 

[Joe4]

Welcome to the Board!

Take a look at the NETWORKDAYS function, i.e. https://www.techonthenet.com/excel/formulas/networkdays.php

So the formula in C1 would look like:

=NETWORKDAYS(TODAY(),B1)

By the way, I get -5, not -4 for your first example (days 8,9,12,13,14).
Maybe you are in a different time zone than me!

 

[Applemoose]

Thank you!
Both formulas seem to work.

Only difference is that =NETWORKDAYS(TODAY(),B1) gives 1 day extra when there's a negative outcome compared to =NETWORKDAYS(TODAY(),B1)+(TODAY()>B1)

Thank you so much for your help