Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Dec 2009
    Location
    Denver, Colorado, USA
    Posts
    126
    Thanks
    8
    Thanked 3 Times in 3 Posts
    I have discovered a very useful Excel function (DATEDIF) that executes in Excel 2003, but doesn't show up in the list of available functions.

    How can I add this function to the dropdown menu of available functions?

    Thanks.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Ron,

    The only way I can come up with w/o some fancy programming would be to create your own Public Function with a slightly different name like MyDateDif that would accept the same arguments and return the answer as a variant and then just pass the received arguments on to the DateDif() function and pass back to the worksheet the answer.
    Code:
    Public Function MyDateDif(Date1 as Variant, Date2 as Variant,Interval as Variant) as Variant
    
      MyDateDif = DateDif(Date1, Date2, Interval)
    
    End     'MyDateDif()
    Happy Holidays.

    P.S. It will show up under the User Defined category or the All category. It will NOT show under the Date Category.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

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