WORKDAY()

Computed date excluding non-work days

Returns the date computed by adjusting the date by the number of workdays. A workday is any Monday through Friday, excluding any dates specified by the optional holidays list.

Sample usage

WORKDAY(TODAY(), 2) returns the date two business days in the future. If today is a Wednesday, the date would be Friday; if today is Thursday, the date would be Monday; if today is Friday, the date would be Tuesday.

WORKDAY(TODAY(), 5) returns five business days (one business week) in the future.

WORKDAY(TODAY(), -5) returns five business days (one business week) in the past.

WORKDAY("12/1/2019", 25, LIST("12/24/2019", "12/25/2019", "1/1/2020")) :returns1/8/2020

WORKDAY([Project Start], [Est Days], Holidays[Date]) computes a project's anticipated end date from its known start date and an estimated number of days of work, taking into account known holidays.

Syntax

WORKDAY(when, days, [holidays])

  • when - A Date value that will be adjusted by days, excluding holidays.
  • days - A number of workdays by which to adjust when. May be positive or negative.
  • holidays - An optional list of dates (Date value) that are not considered workdays.

Note

Some constant values, such as "MM/DD/YYYY", are evaluated as a Date value by AppSheet. Similarly, "000:00:00" is evaluated as a Duration value. This doesn't mean your spreadsheet data must use the same formats: the date and time formats in your spreadsheets are determined by the locale/language setting. Column will always be evaluated as the type of column. Additionally, you can convert data, both columns and string literals, to specific types using functions such as DATE(), TIME(), or DATETIME()

See also

Date and time expressions

EOMONTH()

EWOMONTH()

WEEKNUM()

 

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

true
Search
Clear search
Close search
Google apps
Main menu
17387532164436272180
true
Search Help Center
true
true
true
false
false