If you’re looking to find out the delivery date for a product, the Workday function in Microsoft Excel can be incredibly helpful. In this tutorial, we’ll cover everything you need to know about using this function.
First, let’s take a look at the parameters involved in the Workday function. Essentially, this function returns the serial number of the day before or after a specified number of workdays. You can use it to find the previous workday or the next workday.
To get started, let’s say you have an order date and processing time and you need to find out the delivery date. You also have two holidays during this timeframe that you want to exclude from your processing time. Here’s how you can use the Workday function to find your delivery date:
1. Start by typing “=workday” in a cell.
2. The first parameter is the starting date, in this case the date the order was placed.
3. Note that Workday doesn’t count the starting day as a workday. So if the order was placed on November 10th, the function will start counting from November 11th.
4. The second parameter is the number of working days it will take to process your product. If you have holidays, you can select them here as well.
5. Once you hit enter, you’ll get a serial number like this: 44308. You’ll need to format this cell as a date to get your delivery date.
In our example, the delivery date was November 19th. If you count manually, you’ll see that the Workday function excluded the two holidays and weekends and gave us the correct delivery date.
If you need to apply the formula to multiple cells, simply click and drag to copy it.
Using the Workday function in Excel is a straightforward way to find out delivery dates while excluding weekends and holidays from your processing time. Give it a try the next time you need to calculate delivery dates for your products.