How to Use WORKDAY INTL Function in Excel

preview_player
Показать описание
In this Excel Function Explained video series, I will clarify the use of WORKDAY.INTL function in excel. It falls under the "Date and Time" function category. Excel WORKDAY.INTL function is used to return Future or Backdate after or before individual workdays, excluding holidays and weekends. Using this function, you'll be able to display a short date or a long date. It will not only display the date but also format the cell as a date. It works just like the workday function with additional flexibility.

The workday function only allows Saturday and Sunday as weekends. Sometimes we need to modify that. Then workday international or the workday. Intl will allow you to alter that.

Let's learn how to use WORKDAY.INTL formula in excel.

The function looks like this =WORKDAY.INTL (Start Date, Days, Weekends, Holidays)

The function has four arguments or parameters, and they are described below.

1. Start Date: you'll have to insert the starting date in this parameter. Remember, this function won't count the starting date as a working day. Suppose the starting date is 01/12/2020. So, the function will start counting 02/12/2020 as day 1.
2. Days: This is where you specify how many working days you need to advance or backdate. Suppose you need three working days to process your shipment. Then you'll need to write three in this argument.
3. Weekends: In this parameter, you'll have to specify the weekends. This is where this function is different than the workday function. Now there is a chart for selecting the weekends, and they are as follows:

Saturday, Sunday - 1 or omitted
Sunday, Monday - 2
Monday, Tuesday - 3
Tuesday, Wednesday - 4
Wednesday, Thursday - 5
Thursday, Friday - 6
Friday, Saturday - 7
Sunday only - 11
Monday only - 12
Tuesday only - 13
Wednesday only - 14
Thursday only - 15
Friday only – 16
Saturday only - 17

4. Holidays: The most crucial aspect of this excel function is that you can consider other holidays. In this parameter, you need to input all the holidays if you have any. Then the function will exclude these holidays along with the weekends and show you a serial number. That serial number, if formatted correctly, will be your desired working date.

This is how we use WORKDAY.INTL in excel. Remember, using WORKDAY.INTL function in excel you tell excel formula to return past or future date based on Workdays and holidays.

#Excel #Function #WORKDAY.INTL

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:
Рекомендации по теме
visit shbcf.ru