Results 1 to 7 of 7

Thread: Excel Datedif - Days of February

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #5
    Junior Member
    Join Date
    Apr 2012
    Posts
    21
    Rep Power
    0
    Hi Rick
    Yes i agree with you; but i want result as 0 Years 1 Months 0 Days
    PFA workbook hope this will help.
    I have Date1 -01-APR-10 And Date2-31-MAR-11
    I enter no of days leave suppose 31 days then; I deduct 31 days from Date2
    and i get Date3- 28-02-11 in another cell. Then i use datedif for Date3 And Date2.
    it reflect for 31 days - 0 Years 1 Months 3 Days. it should be 0 Years 1 Months 0 Days

    And does this problem exist in only 2007 ?
    Attached Files Attached Files

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. 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
  3. Replies: 0
    Last Post: 09-17-2012, 02:05 PM
  4. The Number of Years, Months and Days Between Two Dates
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 7
    Last Post: 06-08-2012, 10:35 PM
  5. Number of Days In A Month
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 05-14-2011, 08:00 PM

Posting Permissions

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