Number of Working Days until Deadline - Excel Formula

In this video, we calculate the number of working days until a deadline date with an Excel formula.

Excel has two functions for this job. In the video, we demonstrate both of them and talk about their differences.

We also show you how to specify to Excel what a working, or a non-working day is, so that the results are correct and also dynamic.

Find more great free tutorials at;

*** Online Excel Courses ***

Connect with us!

[johncallaghan]

Your videos are brilliant! You keep it so simple and clearly explain formulas and functions which can be a a complete headache! Do you ever answer questions at all? Thanks

[huckleberryeast]

Thank you for the quick and simple explanation.

[briangonsalez]

Excellent video! Thank you very much!!

[soumiamoujane]

I love your videos they are great and helpful.

[AlekeyRomanov]

Thank you a lot! I just have a question, is it possible not to include Saturday and Sunday? I want to countdown all days until the deadline. Thanks.

[langashouse]

This was so well explained and clear. Thanks

[ShinoOngPeiSun]

Thanks for the great video. Is it possible to show "0" days after it passed the deadline?

[nhlanhlachauke]

hi, how to stop countdown with the end date?

[mohideenthassim]

Very useful video Alan, I did not know that function existed, Thank you! very much for all your hard work, appreciate it very much.

[abdulhamidalhaddadi]

how can I make the 1st day of each month + 10 working days automaticly insert in cell A1?
Thank you

[adityapingle]

Can we start timer by adding date and time and timer should start with real/current time...can we do that?

[massimotrevisan]

Hi. Is it possible to do the same on datas representing expiring hours of a spare part instead of a date? If so, could you please explain it?

[justinllames]

Hi is there anyway to maximize the dates to 7days only& so it expires every 7days?

[minallboy]

Does this not work on excel 365? It works on my desktop version but I want t share a live working document and I just get 'VALUE'. But the formatting is the same across both.

[dvaltinio]

i tried it with excel 365, not working. #VALUE! always shows up. what should i do?

[tareqbamuqabel]

I need your help, I have the number of tasks specified per week, how can I estimate the due date for that?

[jamieseverio]

I want to INCLUDE weekends AND holidays. How does that work ?

[palashsethi]

I have applied it. But it's coming there #value! How to solve this??

[LolaCopacabanita]

Why does my days show a minus sign, like -32, -30, -12 etc?

[YagoCamargo]

Guys, about Excel, do you know any formula for bringing the number of the working day of the month? Ex 3/15/2021 = 11, 3/16/2021 = 12