Tick Tock: Calculating Workdays Between Dates In Excel


Christmastime!  The lights, the food, the time with family, and the opportunity to celebrate the One who changed everything...

...but

...it's only April. 

Want to know how many workdays until Christmas in two shakes of a reindeer's tail?  Here's how to do it with the NETWORKDAYS() function.

First we want to make sure we have our start and end dates handy.

Now we know from earlier this week that calculating the straight number of days is just a subtraction of later date minus early date.

But how do we calculate the number of work days?  Easy!

=NETWORKDAYS(startdate,enddate)

Only 186 workdays until Christmas!  JOY!!!

Need help with dates or other Excel elements?  Contact us via live chat, email at support@spreadsheetsherpa.com, or call 877.851.0132 today!