+ Reply to Thread
Results 1 to 9 of 9

How many years from start date formula

Hybrid View

  1. #1
    Forum Expert Roel Jongman's Avatar
    Join Date
    03-28-2015
    Location
    Netherlands
    MS-Off Ver
    Office 365
    Posts
    1,491

    Re: How many years from start date formula

    The DATEDIF formula is a bit of a special story.. it is officially not supported in excel and therefor not in the list of formula's (I believe there were lawsuits against MS for copyright infringements)
    it is however available in the background but you will have to know (or find on internet) how to use it as the normal help to setup the formula is not available

    It is the right formula to use however..
    I also put a small lookup table for the year ranges that is easier then nested if formula's

    Edit: I see humdingaling in post #2 also posted a link, that link has a clear list of available options, make sure to check that is you also want months or days sincs start
    Attached Files Attached Files
    Last edited by Roel Jongman; 04-26-2018 at 04:16 AM.

  2. #2
    Registered User
    Join Date
    01-08-2018
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    14

    Re: How many years from start date formula

    How do I get it from the 'background'? Seems silly that it doesn't show up!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Split Start End date into multiple years
    By tos in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-25-2016, 06:42 AM
  2. [SOLVED] Help in writing formula in excel to produce dates based on start date and end date
    By shoot for moon in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-10-2014, 01:00 PM
  3. How to spread annual forecasts by month across fiscal years by variable start date
    By gbolanis in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-21-2013, 11:59 AM
  4. [SOLVED] How to determine how many fiscal years are present from start date to end date.
    By terrivega3500 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-07-2012, 01:25 PM
  5. defining a years length(start and end dates)
    By wheefus in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-13-2008, 11:44 AM
  6. Start Date minus (Years + Months + Days) = ?
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-11-2006, 01:10 PM
  7. [SOLVED] Date Formula - in Years
    By Jenny Potter in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-20-2006, 05:30 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1