+ Reply to Thread
Results 1 to 3 of 3

Thread: DATEDIF - Hidden Function

  1. 03-21-2011, 11:14 PM #1
    billybobb
    billybobb is offline
    Registered User
    Join Date
    02-27-2011
    Location
    nyc
    MS-Off Ver
    Excel 2007
    Posts
    12

    DATEDIF - Hidden Function

    Hey,

    I cant seem to get this DATEDIF function to work, i seem to be using it correctly. Please advise.

    Thanks,

    MIke
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 03-21-2011, 11:54 PM #2
    queslake
    queslake is offline
    Registered User
    Join Date
    11-18-2010
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: DATEDIF - Hidden Function

    try this
    =DATEDIF(E4,E6,"Y")
    you forgot the "" in the Y
    Reply With Quote Reply With Quote
  3. 03-22-2011, 04:28 AM #3
    DonkeyOte
    DonkeyOte is offline
    Forum Moderator DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Suffolk, UK
    MS-Off Ver
    2002, 2007 & 2010
    Posts
    21,423

    Re: DATEDIF - Hidden Function

    For info. on DATEDIF see: http://www.cpearson.com/excel/datedif.htm
    My Recommended Reading:

    Volatility
    Sumproduct & Arrays
    Pivot Intro
    Email from XL - VBA & Outlook VBA
    Function Dictionary & Function Translations
    Dynamic Named Ranges
    Reply With Quote Reply With Quote
+ 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)

Tags for this Thread

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