+ Reply to Thread
Results 1 to 5 of 5

Not all functions on excel

  1. 03-21-2018, 07:09 AM #1
    pccamara
    pccamara is offline
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    177

    Not all functions on excel

    Hello all

    Guys please help me to understand.
    At home, i have Microsoft Office Professional Plus 2016 but i don't have all the functions that i have at the office wich is 365 (...).
    Functions like Datedif, Texjoin, ifs and so on....
    Please feel free to give me your better advice, what do download, add ins....
    Best regards
    Pedro
    Reply With QuoteRegister To Reply
  2. 03-21-2018, 07:19 AM #2
    tim201110
    tim201110 is offline
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Not all functions on excel

    This feature is only available if you have an Office 365 subscription.

    Datedif exists in usual 2016
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 03-21-2018, 07:27 AM #3
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: Not all functions on excel

    See: https://support.office.com/en-us/art...3-0e8fc845691c
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  4. 03-21-2018, 07:33 AM #4
    pccamara
    pccamara is offline
    Forum Contributor
    Join Date
    03-24-2014
    Location
    Lisboa, Portugal
    MS-Off Ver
    Office 365
    Posts
    177

    Re: Not all functions on excel

    Hello TMS
    That reason didn't cross my mind since i have office professional pro....
    Tks a lot
    Reply With QuoteRegister To Reply
  5. 03-21-2018, 10:41 AM #5
    TMS
    TMS is online now
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: Not all functions on excel

    You're welcome. Thanks for the rep.


    Tim also provided a response, covering both points. I just followed up on his answer.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Add Spanish Excel Functions Library/Database to US version of Excel
    By chris14jan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-15-2013, 05:02 PM
  2. use user functions in excel from other excel using direct reference
    By Maica Boa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-12-2013, 07:34 AM
  3. Which Excel functions work in user-defined functions ?
    By RogeratCCCC in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 04-28-2012, 06:47 PM
  4. Excel 2007 : Calling functions based on input values in Excel 07 (functions array?)
    By duby13 in forum Excel General
    Replies: 1
    Last Post: 02-10-2012, 05:27 PM
  5. excel functions similar/the same as VBA functions
    By FRIEL in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2008, 05:39 AM
  6. AVERAGEIFS, SUMIFS and COUNTIFS Functions New functions in Excel 2007
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 11-15-2007, 05:24 AM
  7. [SOLVED] User-defined functions created in Excel 2000 fail in Excel 2003
    By goodguy in forum Excel General
    Replies: 1
    Last Post: 10-03-2005, 03:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1