Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Subtotal function in Excel
  • Chart Axes in Excel
  • Number and Text Filters Examples in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • Excel Frequency Function Example

References

  • Get nth match with INDEX / MATCH in Excel
  • How to get relative column numbers in a range in Excel
  • Find closest match in Excel
  • Count rows with at least n matching values
  • How to use Excel COLUMN Function

Data Validations

  • Excel Data validation number multiple 100
  • Excel Data validation require unique number
  • Excel Data validation exists in list
  • How To Create Drop-down List in Excel
  • Prevent invalid data entering in specific cells

Tag: WORKDAY.INTL function

WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation

by

What is WORKDAY.INTL function in Excel? WORKDAY.INTL function is one of Date and Time functions in Microsoft Excel that returns the serial number of the date before or after a specified number of workdays with custom weekend parameters. Weekend parameters indicate which and how many days are weekend days. Weekend days and any days that are specified …

Continue Reading

Add days exclude certain days of week in Excel

by

It you need to add days and exclude certain days of week in Excel then this tutorials is for you. To add days to a date while excluding specific days (i.e. exclude Tuesdays and Thursdays, Wednesdays only, etc.) you can use the WORKDAY.INTL function with a special pattern code see the example below: Formula =WORKDAY.INTL(date,days,”pattern”) Explanation …

Continue Reading

Get project end date in Excel

by

To calculate a project end date based on a start date and duration, you can use the WORKDAY function. Formula =WORKDAY(start,days,holidays) Explanation In the example shown, the formula in E5 is: =WORKDAY(C5,D5,holidays) where “holidays” is the named range G5:G9. How this formula works This formula uses the WORKDAY function to calculate an end date. WORKDAY can calculate dates …

Continue Reading

Get project midpoint in Excel

by

To calculate an approximate project midpoint date, you can use the WORKDAY function. Note: The WORKDAY function returns a date in the future or past, based on a start date, workdays, and optional holidays. WORKDAY automatically excludes weekends, and counts only Monday through Friday as workdays. Formula =WORKDAY(start,days/2,holidays) Explanation In the example shown, the formula in E5 …

Continue Reading

How to calculate project start date based on end date in Excel

by

To calculate a project start date or custom date based on an end date and duration in days, you can use the WORKDAY function. Note: WORKDAY function does not count the start date as a workday. Formula =WORKDAY(start,-days,holidays) Explanation In the example shown, the formula in E5 is: =WORKDAY(C5,-D5,holidays) where “holidays” is the named range G5:G9. How …

Continue Reading

How to calculate future date say 6 months ahead in Excel

by

— Next business day 6 months in future To get a date 6 months in the future, on the next work day, you can use a formula based on the WORKDAY function, with help from EDATE. Formula =WORKDAY(EDATE(date,6)-1,1,holidays) Explanation In the example shown, the formula in C6 is =WORKDAY(EDATE(B6,6)-1,1,B9:B11) How this formula works Working from …

Continue Reading

How to calculate Next working/business day in Excel

by

To get the next working day, or next business day, you can use the WORKDAY function. Formula =WORKDAY(date,1,holidays) Explanation In the example shown, the formula in C4 is: =WORKDAY(B4,1,holidays) How this formula works The WORKDAY formula is fully automatic. Given a date and days, it will add days to the date, taking into account weekends …

Continue Reading

Add workdays no weekends in Excel

by

It you need to add workdays no weekends in Excel then this tutorials is for you. See example below: Therefore, To add or subtract workdays days to a date, respecting holidays but assuming a 7-day workweek, you can you can use the WORKDAY.INTL function. Formula =WORKDAY.INTL(start_date,days,”0000000″, holidays) Explanation In the example, the formula in D6 is: =WORKDAY.INTL(B6,C6,”0000000″,holidays) …

Continue Reading

Add workdays to date custom weekends in Excel

by

It you need to add workdays to date custom weekends in Excel then this tutorials is for you. See the example below. To add or subtract workdays days to a date so that you can calculate a date in the future or past that skips weekends (customized) and holidays , you can use the WORKDAY.INTL function. Holidays …

Continue Reading

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to use Excel OR Function
  • IF, AND, OR and NOT Functions Examples in Excel
  • IFNA function: Description, Usage, Syntax, Examples and Explanation
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • How to get year from date in Excel
  • Get age from birthday in Excel
  • Convert decimal seconds to Excel time
  • ISOWEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Sum through n months in Excel

Grouping

  • Calculate conditional mode with criteria in Excel
  • How to randomly assign people to groups in Excel
  • Group arbitrary text values in Excel
  • Map inputs to arbitrary values in Excel
  • Categorize text with keywords in Excel

General

  • How to add sequential row numbers to a set of data in Excel
  • How to Create Calendar in Excel
  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • How to Delete Cells, Row and Rows in Excel
  • Convert column letter to number in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning