Study guide

10.2 Business Date Calculations: WORKDAY, NETWORKDAYS, EDATE, & EOMONTH

Microsoft Excel Expert Microsoft 365 Apps

Track your progress as you read

Finished sections get a check mark.

1 Chapter 1: Exam Overview & MO-211 Fundamentals

1.1 MO-211 Exam Structure, Scoring, & Performance-Based Strategy 1.2 Excel Environment & Microsoft 365 Architecture

2 Chapter 2: Managing Workbooks & File Options

2.1 Workbook Versioning, AutoRecover, & File Properties 2.2 External Data Referencing & Cross-Workbook Formulas 2.3 Macro Security, Portability, & Workbook Distribution

3 Chapter 3: Workbook Protection & Collaboration Settings

3.1 Cell Locking, Range Permissions, & Worksheet Protection 3.2 Workbook Structure Protection & Editing Restrictions 3.3 Formula Calculation Options & Iterative Calculations

4 Chapter 4: Advanced Data Entry & Series

4.1 Flash Fill Patterns & Text Extraction Techniques 4.2 Advanced Fill Series (Linear, Growth, Date, & Step Configurations) 4.3 Dynamic Sequence & Random Data Generation (RANDARRAY, SEQUENCE)

5 Chapter 5: Custom Formatting & Data Validation

5.1 Custom Number Formatting Syntax & Masking Rules 5.2 Data Validation Criteria & Custom Formula Rules 5.3 Validation Input Messages, Error Alerts, & Data Circle Auditing

6 Chapter 6: Data Grouping, Summarization, & Cleansing

6.1 Data Grouping, Ungrouping, & Multi-Level Outlining 6.2 Subtotal Insertion & Summary Function Calculations 6.3 Duplicate Record Removal & Text-to-Columns Cleansing

7 Chapter 7: Advanced Conditional Formatting & Filtering

7.1 Formula-Based Conditional Formatting & Logical Tests 7.2 Data Bars, Color Scales, Icon Sets, & Rule Hierarchy 7.3 Advanced Filtering with Complex Criteria Ranges

8 Chapter 8: Logical Operations & Advanced Multi-Condition Functions

8.1 Nested IF, IFS, & SWITCH Logical Structures 8.2 Compound Boolean Logic: AND, OR, NOT, & XOR 8.3 Multi-Criteria Aggregations: SUMIFS, COUNTIFS, AVERAGEIFS, MAXIFS, & MINIFS

9 Chapter 9: Advanced Lookup Functions & Variable Optimization

9.1 Modern Lookups with XLOOKUP & XMATCH 9.2 Classic Matrix & Two-Way Lookups: INDEX & MATCH 9.3 Formula Optimization & Variable Assignment with LET

10 Chapter 10: Date, Time, Text, & Auditing Functions

10.1 Current Date, Time, & Day-of-Week Functions: NOW, TODAY, & WEEKDAY 10.2 Business Date Calculations: WORKDAY, NETWORKDAYS, EDATE, & EOMONTH 10.3 Modern Text Extraction & Array Splitting: TEXTSPLIT, TEXTJOIN, TEXTBEFORE, TEXTAFTER 10.4 Error Handling & Formula Auditing Tools

11 Chapter 11: Dynamic Array Functions & Spill Operations

11.1 Array Filtering & Extraction: FILTER Function 11.2 Multi-Level Sorting: SORT & SORTBY Functions 11.3 Deduplication & Sequence Arrays: UNIQUE & Array Reshaping

12 Chapter 12: Data Analysis, What-If Tools, & Financial Functions

12.1 Summarizing Multiple Ranges with the Consolidate Feature 12.2 What-If Analysis: Goal Seek & Scenario Manager 12.3 Financial Modeling Functions: PMT, NPER, & Forecast Logic

13 Chapter 13: Macro Automation & VBA Fundamentals

13.1 Recording Macros with Absolute vs. Relative References 13.2 Macro Storage, Shortcut Assignment, & Form Control Buttons 13.3 Managing & Modifying VBA Code in the Visual Basic Editor

14 Chapter 14: Advanced & Specialized Visualizations

14.1 Statistical Visualizations: Histograms & Pareto Charts 14.2 Hierarchy & Financial Visualizations: Waterfall, Funnel, Treemap, & Sunburst 14.3 Distribution & Multi-Axis Charts: Box & Whisker & Dual-Axis Combo Charts

15 Chapter 15: PivotTable Construction & Field Configuration

15.1 PivotTable Data Architecture, Layouts, & Style Configuration 15.2 Field Summarization, Number Formatting, & Custom Calculations 15.3 Value Display Modes: % of Total, Running Total, & Differences

16 Chapter 16: PivotTable Grouping, Slicers, & PivotCharts

16.1 Date & Numeric Field Grouping Strategies 16.2 Calculated Fields & Calculated Items in PivotTables 16.3 Slicers, Timelines, Report Connections, & PivotCharts

10.2 Business Date Calculations: WORKDAY, NETWORKDAYS, EDATE, & EOMONTH

Key Takeaways Explain This Topic AI

Excel stores dates as continuous integer serial numbers where day 1 represents January 1, 1900, while times are stored as fractional decimals of a 24-hour day (e.g., 0.25 represents 6:00 AM and 0.5 represents 12:00 PM).

WORKDAY advances or regresses a start date by a specified count of business days excluding standard weekends (Saturday/Sunday) and optional holidays, whereas WORKDAY.INTL supports customizable weekend schedules via numeric codes or 7-character binary strings.

NETWORKDAYS and NETWORKDAYS.INTL calculate the total number of whole working days between two dates inclusively, counting both the start date and the end date if they fall on working days.

EDATE calculates the exact same calendar day N months in the future or past, automatically adjusting to the final day of shorter months to prevent invalid date errors.

EOMONTH computes the exact last calendar day of the month offset by N months (where 0 targets the current month-end), serving as an indispensable tool for financial accounting accruals, loan amortization schedules, and revenue cutoffs.

Last updated: September 2026

Business Date Calculations: WORKDAY, NETWORKDAYS, EDATE, & EOMONTH

Once a date is anchored and classified, the exam moves to date arithmetic : stepping a milestone forward through business days, counting the working days inside a window, and pinning accounting cutoffs to month boundaries. Four function families carry that load — WORKDAY / WORKDAY.INTL , NETWORKDAYS / NETWORKDAYS.INTL , EDATE , and EOMONTH — and each returns a raw date serial that you are expected to format correctly.

Project Scheduling: WORKDAY vs. WORKDAY.INTL

Standard calendar addition ( start_date + days ) fails when project tasks must account for non-working weekends and official organization holidays. The WORKDAY family calculates milestone dates by stepping forward or backward exclusively through business days.

1. Standard WORKDAY Syntax =WORKDAY(start_date, days, [holidays])

start_date : A valid Excel date serial number or cell reference representing the initial milestone.

days : The number of non-weekend, non-holiday days to advance (positive integer) or regress (negative integer).

[holidays] : An optional contiguous range, array constant, or named range containing serial dates to exclude from the count.

WORKDAY assumes a rigid, Western five-day workweek where Saturday and Sunday are always treated as non-working days. If a task begins on a Friday and requires 1 working day, =WORKDAY(Friday, 1) skips Saturday and Sunday, returning Monday.

2. WORKDAY.INTL for Global Schedules

Global organizations, shift-based operations, and regional markets frequently operate under non-standard workweeks. The WORKDAY.INTL function introduces a customizable [weekend] argument: =WORKDAY.INTL(start_date, days, [weekend], [holidays])

Custom Weekend Configuration: Numeric Codes vs. Binary Strings

The [weekend] argument in WORKDAY.INTL (and NETWORKDAYS.INTL ) accepts two distinct formatting methodologies: Numeric Identifiers and 7-Character Binary Strings .

Numeric Weekend Identifiers

Excel provides standardized numeric codes representing common one-day and two-day weekend configurations:

  • Weekend Code Non-Working Days (Weekend) Operational Context
  • 1 (or omitted) Saturday, Sunday Standard Western business workweek
  • 2 Sunday, Monday Hospitality, retail, and post-weekend recovery
  • 3 Monday, Tuesday Service industries and specialized trade rotations
  • 4 Tuesday, Wednesday Shift schedules
  • 5 Wednesday, Thursday Shift schedules
  • 6 Thursday, Friday Regional Middle East public sector schedules
  • 7 Friday, Saturday Traditional Middle East commercial workweek
  • 11 Sunday only Six-day manufacturing and international retail
  • 12 Monday only Tuesday–Sunday operational schedules
  • 13 Tuesday only Wednesday–Monday schedules
  • 14 Wednesday only Thursday–Tuesday schedules
  • 15 Thursday only Friday–Wednesday schedules
  • 16 Friday only Saturday–Thursday schedules
  • 17 Saturday only Sunday–Friday commercial schedules
  • 7-Character Binary Weekend Strings

When operational teams utilize unconventional non-working days (such as Wednesday and Sunday off), numeric codes cannot fulfill the requirement. Candidates can pass a 7-character text string enclosed in double quotation marks.

Each position represents a day of the week, strictly ordered from Monday through Sunday : MTWTFSS .

A value of 1 designates a non-working day (weekend/off).

  • A value of 0 designates a working day . Character Position: 1 2 3 4 5 6 7
  • Day of Week: Mon Tue Wed Thu Fri Sat Sun
  • "0000011" 0 0 0 0 0 1 1 --> Sat & Sun Off (Standard)
  • "1000000" 1 0 0 0 0 0 0 --> Mon Off Only
  • "0000110" 0 0 0 0 1 1 0 --> Fri & Sat Off
  • "1010100" 1 0 1 0 1 0 0 --> Mon, Wed, Fri Off

Warning

An invalid binary string consisting entirely of ones ( "1111111" ) indicates zero working days in a week and causes Excel to immediately return a #VALUE! error.

Workday Interval Calculations: NETWORKDAYS & NETWORKDAYS.INTL

While WORKDAY calculates a future or past date based on a day offset, NETWORKDAYS performs the inverse calculation: it counts the total number of whole business days between two dates. =NETWORKDAYS(start_date, end_date, [holidays])

  • =NETWORKDAYS.INTL(start_date, end_date, [weekend], [holidays])
  • The Inclusive Boundary Rule

A critical architectural feature tested heavily on MO-211 is inclusive boundary counting . If start_date and end_date fall on the same working day (e.g., Wednesday, October 7 to Wednesday, October 7), NETWORKDAYS returns 1 . Standard calendar subtraction ( end_date - start_date ) returns 0 .

If start_date occurs after end_date , NETWORKDAYS returns a negative integer, accurately representing negative elapsed working time. =NETWORKDAYS(DATE(2026, 10, 5), DATE(2026, 10, 9)) // Returns 5 (Mon to Fri inclusive)

  • =NETWORKDAYS.INTL(DATE(2026, 10, 5), DATE(2026, 10, 9), 7) // Returns 4 (Mon, Tue, Wed, Thu; Fri is off)
  • Milestone & Cutoff Modeling: EDATE & EOMONTH

Financial contracts, debt maturity schedules, insurance policies, and subscription billing cycles typically recur on monthly or quarterly cycles rather than working-day increments.

1. EDATE: Preserving Calendar Day Coordinates

The EDATE function calculates the exact same calendar day N N N months in the future or past: =EDATE(start_date, months)

months : The number of months to advance (positive) or regress (negative).

If a loan originates on January 15, 2026, =EDATE(A2, 6) returns July 15, 2026. If the target month has fewer days than the starting day (for instance, January 31 advanced by 1 month), EDATE automatically adjusts downward to the valid terminal day of that month (February 28, or February 29 in leap years), preventing invalid date errors.

2. EOMONTH: Calculating Accounting Cutoff Dates

Accounting accruals, depreciation tables, and tax reporting require anchoring calculations to the final calendar day of a month. The EOMONTH function returns the date serial number for the last day of the month offset by N N N months: =EOMONTH(start_date, months)

  • Formula Configuration Evaluation Target Financial Modeling Application
  • =EOMONTH(A2, 0) Last day of the current month Current period accrual cutoffs and closing adjustments
  • =EOMONTH(A2, 1) Last day of the following month Net-30 payment due dates anchored to next month-end
  • =EOMONTH(A2, -1) Last day of the prior month Balance sheet opening balances and prior-period reconciliations
  • =EOMONTH(A2, -1) + 1 First day of the current month Dynamic generation of period starting dates
  • High-Frequency MO-211 Exam Scenarios & Traps

The General Number Format Trap : Functions such as EDATE , EOMONTH , and WORKDAY return raw date serial numbers (e.g., 46207 ). If the target cell is formatted as General , the cell displays a five-digit number. Candidates must apply a Short Date or Long Date number format to satisfy project grading rubrics.

String Date Literals : Entering text dates directly into formulas (e.g., =WORKDAY("10/05/2026", 10) ) introduces regional parsing failures if the grading environment uses DD/MM/YYYY instead of MM/DD/YYYY . Always build dates using the DATE(year, month, day) function.

Duplicate Holiday Deduction : If an optional holiday listed in [holidays] coincides with a natural weekend day (e.g., a holiday falling on a Saturday), Excel does not deduct the day twice. The algorithm discounts each unique non-working day exactly once.

Binary Weekend Alignment : The first character in a binary weekend string is always Monday , and the seventh character is always Sunday . Inverting the string or omitting characters causes miscalculations or syntax errors.