To use the WEEKDAY or WORKDAY function in Excel, follow these steps:
- Open an Excel worksheet.
- Type in the start date and end date of your desired range of dates
in two separate cells. - Select the cell you want to display the weekday or workday result in.
- Type =WEEKDAY or =WORKDAY into the formula bar for that cell.
- Select the start date cell reference, followed by a comma.
- Enter the number of days you want to add or subtract
from the start date in the parentheses. - Press Enter to complete the function.