Counting down weekdays from a date in a column (Formula?)

[Halleniusen]

Hello! I'm in dire need of some help I am not very experienced with excel.

I have got a excel document that has some columns in it. 2 of which are important now.

H: Orderdate I: Days left to deliver

What i need to do is have a countdown in "Days left to deliver" that is connected with H


H:Orderdate I:Days left to deliver
2017-03-03 10 days (weekdays)

We have to deliver within 10 days.

Is there a way to craft such a forula? Note that weekends should not count.

I hope this makes sense Thanks in advance guys, I love excel but damn its hard to get into.

//Hallenius

[samba_ravi]

=WORKDAY(h1,10)
is this you are looking for

[Phuocam]

Try this ...

=MAX(0,10-NETWORKDAYS(H2,TODAY()))