Results 1 to 7 of 7

Difference between 2 date in months and function EVEN

Threaded View

  1. #1
    Registered User
    Join Date
    01-21-2013
    Location
    barcelona, spain
    MS-Off Ver
    Excel 2010 but 2007 and 2003 too
    Posts
    52

    Difference between 2 date in months and function EVEN

    Hi!
    I want a difference between 2 dates and I want it in months
    But these are differences of ages of children, so if the difference is of few days it has to result 1 month (with EVEN function or similar)
    If I don't put 1 or the 2 dates the space has to be empty
    I tried with this
    =SI.ERROR(REDONDEA.PAR((C5-D5)/31);"")
    that in english is IFERROR and EVEN
    but:
    - there is an other solution to result the exact months of difference between 2 dates? because the months are not always of 31 days as I put
    - with this formula if the difference is of few days it result 2 (?!?)...it should result 1 month
    - If I don't write one or two of the dates it results 0, but I want empty space in this case

    I send an example
    Thanks!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1