[go: up one dir, main page]
Scribd
Upload
53 views1 page

Excel WORKDAY Function Guide

The WORKDAY function in Excel adds a number of workdays to a start date, returning a future or past date that excludes weekends and optional holidays. It takes in the start date, number of workdays to add, and optionally a list of holiday dates. In the example, it shows WORKDAY returning dates 3 days, 24 days, and 18 days from the start dates, skipping weekends and the listed holidays of 12/24/2019, 12/25/2019, and 1/1/2020.

Uploaded by

Muhammad Aldhy Athaillah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
53 views1 page

Excel WORKDAY Function Guide

The WORKDAY function in Excel adds a number of workdays to a start date, returning a future or past date that excludes weekends and optional holidays. It takes in the start date, number of workdays to add, and optionally a list of holiday dates. In the example, it shows WORKDAY returning dates 3 days, 24 days, and 18 days from the start dates, skipping weekends and the listed holidays of 12/24/2019, 12/25/2019, and 1/1/2020.

Uploaded by

Muhammad Aldhy Athaillah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Excel WORKDAY function: adding workdays to the sart date and return a workday in future or past.

Start Date Days Workday Holidays


2/1/2020 3 2/5/2020 12/24/2019
12/3/2019 24 1/9/2020 12/25/2019
January 3, 2020 -18 12/5/2019 1/1/2020

Introduction of the function

The WORKDAY function is used to add a number of workdays to a started date and returns
the future or past workday in a serial number format. Weekend and the holidays you specified
are excluded when calculation. Know more

Required. A
Syntax and arguments number of Optional. A list of
workdays that you dates or an array
want to add to the constant of serial
start date. numbers which are
considered as non-
Required. The starting date workday.
that used to calculate the week begins.
workday.

WORKDAY(start_date,days,[holidays])

Example
days
holidays
start_date

WORKDAY(B4,C4,$F$3:$F$5)

You might also like