Results 1 to 10 of 22

Thread: UDF (user defined function) replacement for Excel's DATEDIF function

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #16
    Senior Member
    Join Date
    Jun 2012
    Posts
    337
    Rep Power
    13
    Alternative:

    Code:
    Function F_datediff_snb(x0 As Date, x1 As Date)
        n = DateDiff("m", x0, x1 + 1) + (Day(x1 + 1) < Day(x0))
        
        Y = n \ 12
        M = n Mod 12
        D = 1 + x1 - DateAdd("m", M, DateAdd("yyyy", Y, x0))
        
        F_datediff_snb = IIf(Y = 0, "", Y & " year" & IIf(Y = 1, " ", "s ")) & IIf(M = 0, "", M & " month" & IIf(M = 1, " ", "s ")) & IIf(D = 0, "", D & " day" & IIf(D = 1, " ", "s "))
    End Function
    Last edited by snb; 08-27-2013 at 11:43 PM.

Similar Threads

  1. Recommendation: Do not use the undocumented DATEDIF function
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 4
    Last Post: 05-16-2015, 10:06 PM
  2. How To Use Frequency Function In Excel
    By Transformer in forum Familiar with Commands and Formulas
    Replies: 1
    Last Post: 04-09-2013, 11:49 AM
  3. Creating drop-down function in excel
    By Jorrg1 in forum Excel Help
    Replies: 4
    Last Post: 01-09-2013, 01:45 PM
  4. Nested Search Function Excel Formula
    By trankim in forum Excel Help
    Replies: 6
    Last Post: 10-29-2012, 10:29 PM
  5. Excel Nested IF Function With 3 Conditions
    By patsir in forum Excel Help
    Replies: 3
    Last Post: 08-25-2012, 07:15 PM

Tags for this Thread

Posting Permissions

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