Forum Discussion

Thaddeus Severy's avatar
Thaddeus Severy
Copper Contributor
Apr 29, 2018

ROUNDING an DATEDIF function

Greetings, my name is Thaddeus.

    I am a novice excel user.  I am having trouble rounding a DATEIF function.  So I am wondering if someone can simply add to my existing formula.

    My goal is to round months to tenths. Example: 4.7 months.

Here is my current formula:  =DATEDIF(A3,B3,"m")  Which returns whole months, but I would like to break it down to tenths.

Thank you for any help you can offer with this issue.
Thaddeus

Formulas and Functions

2 Replies

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Apr 29, 2018

    Hi Thaddeus,

     

    DATEDIF always returns a whole number, it's programmed this way!

    So you have to replace it with another formula like this:

    =ROUND((B3-A3)/30,1)

     

    Regards

    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Apr 29, 2018

      Or use a more precise value for month length: 365,2425/12 = 30,354166666

Resources