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

Data Analysis

  • How To Sort One Column or Multiple Columns in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • How to calculate current stock or inventory in Excel
  • Conditional Formatting Icon Sets Examples in Excel

References

  • MATCH function: Description, Usage, Syntax, Examples and Explanation
  • How to get relative column numbers in a range in Excel
  • How to use Excel ROW Function
  • Two-way lookup with VLOOKUP in Excel
  • Two-column Lookup in Excel

Data Validations

  • Excel Data validation no punctuation
  • How To Create Drop-down List in Excel
  • Excel Data validation unique values only
  • Excel Data validation must contain specific text
  • Excel Data validation allow uppercase 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

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

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 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

  • Return blank if in Excel
  • Check multiple cells are equal in Excel
  • SWITCH function: Description, Usage, Syntax, Examples and Explanation
  • Not Equal To ‘<>‘ operator in Excel
  • IF, AND, OR and NOT Functions Examples in Excel

Date Time

  • Calculate time difference in hours as decimal value in Excel
  • How to get number of days, weeks, months or years between two dates in Excel
  • How to Calculate Age in Excel
  • Calculate number of hours between two times in Excel
  • Add business days to date in Excel

Grouping

  • Group times into unequal buckets in Excel
  • Group numbers with VLOOKUP in Excel
  • How to randomly assign people to groups in Excel
  • Group numbers at uneven intervals in Excel
  • Group arbitrary text values in Excel

General

  • How to calculate percentage discount in Excel
  • Count cells that do not contain many strings in Excel
  • Using Existing Templates in Excel
  • Create dynamic workbook reference to another workbook in Excel
  • Check if multiple cells have same value in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning