What does it do?

Adds/Subtracts a specified number of workdays to a Date, which will give you a Future/Past Date

Formula breakdown:

=WORKDAY(start_date, days, [holidays])

What it means:

=WORKDAY(specified date, number of work days to add/subtract, [holidays to be considered])

If you want to calculate the future date based on a number of working days added, it will be difficult to manually calculate this!

The hard way: I would normally grab my calendar, and count the days one by one!

The easy way: Excel’s WORKDAY formula!

I explain how you can do this below:


STEP 1: We need to enter the WORKDAY function in a blank cell:


Workday Formula in Excel


STEP 2: The WORKDAY arguments:


What is the specified date?

Select the cell containing the date you want to add the number of workdays to:


Workday Formula in Excel


How many work days to be added?

Select the cell containing the number of work days to be added (i.e The number of non-weekend and non-holiday days after the start date):


Workday Formula in Excel


Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

You now have your future dates with the work days added!

Workday Formula in Excel


How to Use the Workday Formula in Excel

Workday Formula in Excel



Workday Formula in Excel

If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

BETWEEN Formula in Excel There is no explicit Between formula in Excel, however we can come up with creative ways to create this functionality. Our goal is to evaluate if a given value is between a range, for example, is 6 between 1 and 10?We have three possible scenarios: numbers, dates, and text. ...
Remove Second Hyphen with Excel’s SUBSTITUTE... What does it do?Substitutes new_text for old_text in a text string.Formula breakdown:=SUBSTITUTE(text, old_text, new_text, )What it means:=SUBSTITUTE(This cell, By this text character, To this text character, )There are times where I needed to remove t...
Getting the remainder with Excel’s MOD Formu... What does it do?Gives you the remainder after dividing one number with anotherFormula breakdown:=MOD(number1, number2)What it means:=MOD(a number, divided by this number)In Excel it is very easy to divide two numbers.But how about if you need to ge...
Extract First Name From Full Name in Excel There were countless times when I had a list of full names, and all I needed was the First Name. It would be time-consuming to manually get the first names one by one. Thank goodness there are formulas to make my life easier!In Excel, it's very easy to do that with the LEFT a...