Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Convert text string to valid reference in Excel using Indirect function
  • Extract data with helper column in Excel
  • Lookup entire row in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • Basic INDEX MATCH approximate in Excel

Data Analysis Examples

  • Excel Frequency Function Example
  • Remove Duplicates Example in Excel
  • Conditional Formatting Data bars Examples in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Conditional Formatting Color Scales Examples in Excel

Data Validation Examples

  • Prevent invalid data entering in specific cells
  • Excel Data validation don’t exceed total
  • Excel Data validation exists in list
  • Excel Data validation date in specific year
  • Excel Data validation allow weekday only

How to get number of days, weeks, months or years between two dates in Excel

by

To get the number of days, weeks or years between two dates in Excel, use the DATEDIF function. The DATEDIF function has three arguments.

1. Fill in “d” for the third argument to get the number of days between two dates.

Note: =A2-A1 produces the exact same result!

2. Fill in “m” for the third argument to get the number of months between two dates.

Worked Example:   How to increase by percentage in Excel

3. Fill in “y” for the third argument to get the number of years between two dates.

4. Fill in “yd” for the third argument to ignore years and get the number of days between two dates.

Worked Example:   DATEDIF function: Description, Usage, Syntax, Examples and Explanation

5. Fill in “md” for the third argument to ignore months and get the number of days between two dates.

6. Fill in “ym” for the third argument to ignore years and get the number of months between two dates.

Important note: the DATEDIF function returns the number of complete days, months or years. This may give unexpected results when the day/month number of the second date is lower than the day/month number of the first date. See the example below.

Worked Example:   How to calculate months between dates in Excel

The difference is 6 years. Almost 7 years! Use the following formula to return 7 years.

Post navigation

Previous Post:

How to enter Today’s Date or Static Date and Time in Excel

Next Post:

Complete List of Excel Text Functions References and Examples

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

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
  • TEXTJOIN function: Description, Usage, Syntax, Examples and Explanation
  • EXACT function: Description, Usage, Syntax, Examples and Explanation
  • Change Case: Uppercase, Lowercase, Propercase in Excel
  • Excel MAX, MATCH and ADDRESS function illustration
  • Join cells with comma in Excel
  • Sum race time splits in Excel
  • Get date from day number in Excel
  • Assign points based on late time in Excel
  • Get days before a date in Excel
  • How to show last updated date stamp in Excel
  • ODDFPRICE function: Description, Usage, Syntax, Examples and Explanation
  • SLN function: Description, Usage, Syntax, Examples and Explanation
  • DOLLARFR function: Description, Usage, Syntax, Examples and Explanation
  • How to set check register balance in Excel
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles