Results 1 to 5 of 5

Thread: Recommendation: Do not use the undocumented DATEDIF function

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-28-2012, 04:13 AM #3
    Haseeb A
    Haseeb A is offline
    Junior Member Haseeb A's Avatar
    Join Date
    Apr 2011
    Posts
    21
    Rep Power
    0
    I think "md" part can replace by EDATE & DATEDIF("m") part (Fully not sure)

    =DATE(2012,1,5)-EDATE(DATE(2009,6,27),DATEDIF(DATE(2009,6,27),DATE (2012,1,5),"m"))

    Here is the details.
    Last edited by Haseeb A; 02-28-2012 at 04:16 AM.
    Worksheet Functions
    Excel 2003 to Excel 2007 command reference guide
    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