Excel has enormous functions in its pocket. One of them is Workday function.
A workday function helps you to find out the end date of your project. Suppose, you are working in a project for 47 days but you are not sure for what will be your end date cause of the no. of holidays in between, like Sundays or festivals, etc.
So, to figure out the same you can use the workday function of excel. To understand it in a more detailed manner, let’s take an example:
As you can see in the image above, our start date is 1st of January, 2020. The number of days we will be spending on that particular project are 47 in total.
Overall there are 2 holidays in between.
*Please remember that if you have an off on Sunday then you have to mention the dates of the same as well.
Now let’s get started.
The first step is to input the formula:
The formula for the same is
The following formula requires the following data:
Start date- In our example, the start date of the project is 1st of January 2020, i.e. cell D2.
Next is the days, i.e. the no. of days we will be spending on that project which is cell D3, 47 days.
After the same comes the holidays:
As we have only 2 holidays in between, so we have selected the same.
Now all we have to do is press “Enter”
And BAAAMMM here comes our answer i.e. 43896.
You see this is a general write up, to get the same in the date form we have to go to the number settings and choose the option of short date instead of general.
After selecting the same, you get your final date.
In this example, the project end date is 6th of march, 2020.
It’s easy, isn’t it?