Excel WORKDAY.INTL Function
This is a modification of the WORKDAY function as it provides a custom weekend parameter that distinguishes this from the WORKDAY function.
Syntax:
WORKDAY.INTL(start_date,days,[weekends],holidays)
Arguments:
1. start_date: This argument is the date from which the counting of weekdays begins. Excel doesn’t include start_date as a working day.
2. days: This is the number of working days.
3. holidays: This is an optional argument. If the days mentioned include any holidays, then we need to make a list of holidays separately for this and mention it here.
4. weekends: Through this argument, we can specify which days of the week to be treated as non-working days, either by weekend number or specific character string.
Weekend Number
Numbers |
Days |
---|---|
1 (default) |
Saturday, Sunday |
2 |
Sunday, Monday |
3 |
Monday, Tuesday |
4 |
Tuesday, Wednesday |
5 |
Wednesday, Thursday |
6 |
Thursday, Friday |
7 |
Friday, Saturday |
11 |
Sunday |
12 |
Monday |
13 |
Tuesday |
14 |
Wednesday |
15 |
Thursday |
16 |
Friday |
17 |
Saturday |
If this weekend argument is blank in this function, then it will automatically take the combination of Saturday & Sunday.
For instance:
- “0000011”-Saturday & Sunday are weekends(non-working days)
- “1000010”-Monday & Saturday are weekends(non-working days)
Example 1
30 days from the start date, excluding holidays & Sundays, and Monday as weekends (by giving weekend number 2 as arguments).
Example 2
30 days from the start date, excluding holidays & Sunday, Monday as weekends(by giving weekend string “1000001” as arguments).
Example 3
20 days from the start date, no holidays & Monday, and Saturday as weekends (by giving the weekend string “1000010” as arguments).
Excel Date Functions with Formula Examples
There are many functions in Microsoft Excel that may be used to work with dates and timings in Excel. Each function completes a straightforward task, but by combining numerous functions into a single formula, you may handle trickier and more complicated problems. The purpose of discussing DATE functions in Excel is to help different people perform more complex and challenging tasks by combining several functions within one formula.
The DATE function is used to calculate dates in Excel. To work with these formulas you first need to insert the dates in Excel. Excel provides different functions to work with dates & times such as TODAY, NOW, WEEKDAY, EOMONTH, etc. which we will discuss here with examples.
Excel DATE function List
- DATE Function
Get the Current date and Time
- TODAY- It returns today’s date.
- NOW– It returns the current date and time.
Converts Dates to / From text
- DATEVALUE– Helps to Convert date in the text format to date format
- TEXT– It helps to convert a date to a text value.
Retrieve dates in Excel
- DAY– It returns the day of the month
- MONTH– It is used to return the month of a specified date
- YEAR- It is used to return the year of a specified date
- EOMONTH– It returns the last day of the month.
- WEEKDAY– It is used to return the day of the week.
- WEEKNUM– It is used ti return the week number of a date.
Calculate date difference
- DATEDIF– It is used to return the difference between two dates
- EDATE- It is used to return a date N months before or after the start date.
- YEARFRAC- It is used to calculate the fraction of the year between 2 dates.
Calculates Workdays
- WORKDAY- It returns a date N working days in the future or in the past.
- WORKDAY.INTL– It returns a date N weekdays from the start date with custom weekends
Contact Us