{"id":3389,"date":"2014-03-04T14:18:21","date_gmt":"2014-03-04T08:48:21","guid":{"rendered":"http:\/\/trumpexcel.com\/?page_id=3389"},"modified":"2023-09-29T15:22:41","modified_gmt":"2023-09-29T09:52:41","slug":"excel-workday-function","status":"publish","type":"post","link":"https:\/\/trumpexcel.com\/excel-workday-function\/","title":{"rendered":"Excel WORKDAY Function | Formula Examples + FREE Video"},"content":{"rendered":"

Excel WORKDAY Function\u00a0(Examples + Video)<\/span><\/h2>\n

\"EXCEL<\/p>\n

When to use Excel WORKDAY\u00a0Function<\/span><\/h3>\n

Excel WORKDAY function can be used when\u00a0you want to get the date after a given number of working days. For example, if I start a project today and it will take 20 working days to complete it, then I can use the WORKDAY function to get the completion date. This function is best suited when you want to calculate the invoice<\/a> due date, project due date, delivery date, etc.<\/p>\n

This function, by default, takes Saturday and Sunday as the weekend. If you would like to use days other than Saturday and Sunday as the weekend, use Excel WORKDAY.INTL function<\/a>.<\/p>\n

What it Returns<\/span><\/h3>\n

It returns the serial number of the date that is after or before the specified number of working days (from the specified start date).<\/p>\n

Syntax<\/span><\/h3>\n

=WORKDAY(start_date, days, [holidays])<\/p>\n

Input Arguments<\/span><\/h3>\n
    \n
  • start_date \u2013\u00a0<\/strong>a date value that represents the start date.<\/li>\n
  • days<\/strong>\u00a0\u2013 the total number of working days. These exclude\u00a0weekend (Saturday and Sunday). You can use a positive or a negative value here. A positive value calculates the date which is after the start date, and negative value calculates the date before the start date.<\/li>\n
  • [holidays]<\/strong>\u00a0\u2013 (Optional) It is a range of dates that are excluded from the calculations. For example, these could be national\/public holidays. It could be a reference to a range of cells that contains the dates, or could be an array of serial numbers that represent the dates.<\/li>\n<\/ul>\n

    Additional Notes<\/span><\/h3>\n
      \n
    • Saturday and Sunday are considered as the\u00a0weekend and are not counted.\n
        \n
      • In case the weekends are days other than Saturday and Sunday, use WORKDAYS.INTL\u00a0function.<\/li>\n<\/ul>\n<\/li>\n
      • A date can be entered as:\n
          \n
        • A result from some other\u00a0function.<\/li>\n
        • A date stored as text.<\/li>\n
        • A date entered as text (in double quotes).<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n

          Excel WORKDAY Function –\u00a0Examples<\/span><\/h2>\n

          Here are the examples of using the Excel Workday function.<\/p>\n

          #1 Getting the Completion Date after Specified Number of Working Days<\/strong><\/span><\/h3>\n

          Excel Workday function would return the completion date when you specify the start date and the number of working day. It automatically excludes Saturday and Sunday as weekend (non-working days).<\/p>\n

          \"Excel<\/p>\n

          In the above example, the start date is 28 Feb 2016, and the result is 15 July 2016, which is after 100 working days (excluding Saturdays and Sundays).<\/p>\n

          #2 Getting the Completion Date after Specified Number of Working Days (excluding Holidays)<\/strong><\/span><\/h3>\n

          If you want to exclude holidays while calculating the completion date, there is a third argument in the Workday function that lets you specify a list of holidays.<\/p>\n

          \"Excel<\/p>\n

          In the above example, the start date is 28 Feb 2016, and the result is 20 July 2016, which is after 100 working days. The calculation excludes weekends (Saturdays and Sundays) and the specified holidays in C3:C5. In case, a holiday occurs on a weekend, it is counted only once.<\/p>\n

          Excel WORKDAY Function – Video Tutorial<\/span><\/h2>\n