View Categories

How do I use the WEEKDAY or WORKDAY function in Excel?

< 1 min read

To use the WEEKDAY or WORKDAY function in Excel, follow these steps:

  1. Open an Excel worksheet.
  2. Type in the start date and end date of your desired range of dates
    in two separate cells.
  3. Select the cell you want to display the weekday or workday result in.
  4. Type =WEEKDAY or =WORKDAY into the formula bar for that cell.
  5. Select the start date cell reference, followed by a comma.
  6. Enter the number of days you want to add or subtract
    from the start date in the parentheses.
  7. Press Enter to complete the function.

Powered by BetterDocs