Excel has enormous functions in its pocket. One of them is Workday function.

Previously In Excel Formulas: How to use AVERAGEIFS Function in Excel?

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:

WORKDAY Formula

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:

WORKDAY Formula

The formula for the same is 

=WORKDAY(

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.

WORKDAY Formula

Next is the days, i.e. the no. of days we will be spending on that project which is cell D3, 47 days.

WORKDAY Formula

After the same comes the holidays:

WORKDAY Formula

As we have only 2 holidays in between, so we have selected the same.

Now all we have to do is press “Enter”

WORKDAY Formula

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. 

WORKDAY Formula

After selecting the same, you get your final date.

WORKDAY Formula

In this example, the project end date is 6th of march, 2020.

WORKDAY Formula

It’s easy, isn’t it?