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.
 
