Menu
Insights Training
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Home
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn

Blog

Count Tenure with DATEDIF Function

9/22/2017

Comments

 
"DATEDIF" is one of the "phased out" functions in Excel but it still there if you need it.  However, it is not documented in Excel and when you start the function, it does not show its elements so you really need to know how to use it because Excel won't guide you.
 
DATEDIF determines the difference between two dates.  This has been replaced by advanced and more flexible functions DAYS, NETWORKDAYS, and WORKDAYS, together with their .INTL counterparts but DATEDIF still can be handy.
 
The funtions works: =DATEDIF(startdate, enddate, intervaltype)
Picture
The interval type is a code to determine what you are counting between the dates.  You can hardcode the constant letters in between quotation marks (") as the third element in the function.
Picture
This will show 44 because we used letter "d" and there are 44 complete days between Jan 1 2013 and Feb 1 2013.  I have to emphasize "complete" because if you are using other time intervals, it will give you the number of complete months, years, etc.
Picture
Other codes that can be used:
 
"m" for months
"y" for years
"d" for days
 
then the "combo":
 
"ym" which counts the complete calendar months as if they were on the same year (so Jan 1 2013 and Feb 1 2014 will be just 1 unlike if you use "m" which will you 13,)
"yd" which counts the complete calendar days as if they were on the same year, and
"md" which counts the complete calendar days as if they were on the same month and year.
You can also use other cells to give you the interval types which can come handy if you are playing with the function.
Picture
Comments
    View my profile on LinkedIn

    Archives

    April 2020
    May 2019
    September 2017

    Categories

    All
    Excel Functions
    Word Features

    RSS Feed

Home

Courses

Public Classes

Contact

Copyright © 2022