Results 1 to 2 of 2

Thread: Date Formula Help

  1. #1
    Neophyte KhodrK1590's Avatar
    Join Date
    Oct 2021
    Posts
    4
    Articles
    0
    Excel Version
    2021

    Date Formula Help



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I want to make the duration of two dates closest to years in months, what formula would I use?

    for example, I have a start date/end date of
    9/1/21 8/30/26

    when I do DATEIF in months I get 59, however, I want it to round up to the nearest 12 month in years, so for example, I want it to be 60 months.

    what would I add to my formula or how would I write it? Let's say start date is A1 and end date is B1.

    Basically, I have several dates and need them all to be as close to 12 x x as possible.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,718
    Articles
    0
    Excel Version
    MS365 Sub (Insider) Win11
    Try this:

    =MROUND(DATEDIF(A1,B1,"m"),12)
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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