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. 05-16-2015, 10:06 PM #1
    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