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

Data Analysis

  • How to add Trendline to a chart in Excel
  • Everything about Charts in Excel
  • Reverse List in Excel
  • Conditional Formatting New Rule with Formulas in Excel
  • How To Filter Data in Excel

References

  • Excel Advanced Lookup using Index and Match Functions
  • Two-way lookup with VLOOKUP in Excel
  • How to use Excel ROW Function
  • How to get last row in numeric data in Excel
  • Last row number in range

Data Validations

  • Excel Data validation unique values only
  • Excel Data validation must not contain
  • Data validation must not exist in list
  • Excel Data validation date in specific year
  • Excel Data validation allow weekday only

Tag: DATEDIF function

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

by

What is DATEDIF function in Excel? DATEDIF function is one of Date and Time functions in Microsoft Excel that calculates the number of days, months, or years between two dates. Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios. Syntax of DATEDIF function DATEDIF(start_date,end_date,unit) …

Continue Reading

Get days, months, and years between dates in Excel

by

This tutorial show how to Get days, months, and years between dates in Excel using the example below. To calculate and display the time between dates in days, months, and years, you can use the a formula based on the DATEDIF function. Note: The DATEDIF function is designed to calculate the difference between dates in years, …

Continue Reading

Get days between dates ignoring years in Excel

by

To calculate days between two dates, ignoring year values, use the DATEDIF function. Formula =DATEDIF(start_date,end_date,”yd”) In the example shown, the formula in D6 is: =DATEDIF(B6,C6,”yd”) Explanation The DATEDIF function can handle a variety of “date difference” calculations to calculate the difference between two dates in years, months, and days.  DATEDIF takes 3 arguments: start date, …

Continue Reading

How to calculate months between dates in Excel

by

To calculate months between two dates as a whole number, you can use the DATEDIF function. Formula =DATEDIF(start_date,end_date,”m”) Explanation In the example shown, the formula in D6 is: =DATEDIF(B6,C6,”m”) Note that the DATEDIF automatically rounds down. To round up to the nearest month, see below. The mystery of DATEDIF The DATEDIF function is a “compatibility” …

Continue Reading

How to calculate next anniversary date or birthday in Excel

by

To calculate the next anniversary date, you can use a formula based on the EDATE and DATEDIF functions. Case Study: Assume fixing anniversary date as June 1, 2017 in all examples. Formula =EDATE(date,(DATEDIF(date,as_of,”y”)+1)*12) Explanation In the example shown, the formula in D5 is:  =EDATE(B5,(DATEDIF(B5,C5,”y”)+1)*12) This formula will work to calculate next upcoming birthday as well. How this …

Continue Reading

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 …

Continue Reading

How to Calculate Age in Excel

by

To calculate the age of a person in Excel, use the DATEDIF function and the TODAY function. The DATEDIF function has three arguments. 1. Enter the date of birth into cell A2. 2. Enter the TODAY function into cell B2 to return today’s date. 3. The DATEDIF function below calculates the age of a person. Note: fill …

Continue Reading

How to calculate number of Days until Birthday

by

To calculate the number of days until your birthday in Excel, execute the following steps. 1. Enter the date of birth into cell A2. 2. Enter the TODAY function into cell B2 to return today’s date. 3. The most difficult part in order to get the number of days until your birthday is to find your next birthday. The formula …

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

  • Extract multiple matches into separate rows in Excel
  • SWITCH function example in Excel
  • Invoice status with nested if in Excel
  • OR function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel OR Function

Date Time

  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • Display the current date and time in Excel
  • How to calculate next day of week in Excel
  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • Assign points based on late time in Excel

Grouping

  • Group times into 3 hour buckets in Excel
  • Group arbitrary text values in Excel
  • Group numbers at uneven intervals in Excel
  • Map text to numbers in Excel
  • If cell contains one of many things in Excel

General

  • How to Delete Cells, Row and Rows in Excel
  • How to generate random number weighted probability in Excel
  • Automatically fill series of cells in Excel using AutoFill
  • Freeze and Unfreeze Panes in Excel
  • How to set or clear a print area in Excel Worksheet
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning