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:

DOWNLOAD EXCEL WORKBOOK

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

=WORKDAY(

Workday Formula in Excel

 

STEP 2: The WORKDAY arguments:

start_date

What is the specified date?

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

=WORKDAY(C9,

Workday Formula in Excel

days

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(C9, D9)

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

HELPFUL RESOURCE:

 

Workday Formula in Excel

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Round Off Numbers with Excel’s ROUND Formula What does it do?Rounds a number to the nearest decimal based on your specified number of digitsFormula breakdown:=ROUND(number, num_digits)What it means:=ROUND(the number, number of decimal places to round off)Ever had the need to round off numbers? ...
Division Formula in Excel What does it do?Divides two numbersFormula breakdown:=number1 / number2What it means:=the number being divided / the number you are dividing byIn Excel dividing numbers together is really easy!The Division Formula is done through the use of the div...
Count Text Occurrences with Excel’s SUBSTITU... What does it do?It replaces specific text in a text string i.e. Substitutes new text for old text in a text string.Formula breakdown:=SUBSTITUTE(text, old_text, new_text, )What it means:=SUBSTITUTE(This cell, From this TEXT character, To this TEXT character, )...
Calculate the Compound Interest with Excel’s... What does it do?Calculates the compound interestFormula breakdown:=FV(rate, nper, pmt, )What it means:=FV(interest rate, number of periods, periodic payment, initial amount)Say that you turn 18 years today (CONGRATS!) and you find out that your parents...