Meet DATEDIF(), Excel’s secret Date & Time function that’s still handy

    DATEDIF(), which suggests Date + Dif, is a compatibility operate left over from Lotus 1-2-3 that Microsoft adopted in Excel model 2000, which is the one model that explains how this operate works. It’s operational in all Excel variations, nevertheless it’s not on the Formulas menu or within the Help menus after Excel 2000. If your spreadsheet experiences started with Lotus, which is true for a lot of 1000’s of customers, you’ll be completely happy to know that this previous Lotus operate continues to be alive and kicking.

    The goal of this operate is to calculate the time between a user-specified beginning and ending date in days, months, or years. The arguments for this operate are:

    Start_date: begin date in Excel date serial quantity format

    End_date: finish date in Excel date serial quantity format

    Unit: the time unit to make use of (years, months, or days)

    And the syntax appears to be like like this: =DATEDIF(start_date,end_date,unit)

    The “unit” is specified utilizing the unit argument, which is a textual content code. For instance, the next codes clarify how these values are used within the operate’s syntax:

    Use the letter “Y” to specify the distinction in full years

    Recent Articles

    Facebook invests in audio with short-form Soundbites feature, podcast support and a Clubhouse clone – TechSwitch

    Facebook right now formally introduced a collection of recent audio merchandise — a sign that it’s taking the risk from Clubhouse and different audio...

    The best email platforms for iPhone, iPad and Mac users in 2021

    POP3 and IMAP e mail applied sciences are giving strategy to different, extra aggressive options. Here...

    3 ways to build stronger remote teams

    While some corporations are trying to push individuals again to the workplace, thousands and thousands will proceed working from house. That means enterprise professionals...

    The Most Common Xbox Series S Problems and How to Fix Them | Digital Trends

    The Xbox Series S doesn’t have too many points, however the most typical Xbox Series S issues could make it really feel that method....

    Related Stories

    Stay on op - Ge the daily news in your inbox