Results 1 to 5 of 5

Thread: Recommendation: Do not use the undocumented DATEDIF function

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. 02-28-2012, 08:02 AM #1
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi,

    Another thread where it discuss.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
  2. 05-16-2015, 10:06 PM #2
    shg
    shg is offline
    Junior Member
    Join Date
    May 2015
    Posts
    1
    Rep Power
    0
    Rick,

    Row\Col
    A
    B
    1
    12/31/2014
    2
    01/01/2015
    3
    4
    1
    		 A4: =xlDATEDIF(A1, A2, "y")
    5
    0
    		 A5: =DATEDIF(A1, A2, "y")
    6
    7
    1
    		 A7: =xlDATEDIF(A1, A2, "m")
    8
    0
    		 A8: =DATEDIF(A1, A2, "m")


    Is this behavior by design?

    EDIT: I see you already recognized this in the other thread.
    Last edited by shg; 05-17-2015 at 12:09 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. UDF (user defined function) replacement for Excel's DATEDIF function
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 21
    Last Post: 03-07-2015, 09:47 PM
  2. Excel Datedif - Days of February
    By Excelfun in forum Excel Help
    Replies: 6
    Last Post: 06-10-2012, 02:32 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