ROUNDING an DATEDIF function

[Thaddeus Severy]

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

[#2]

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

[#3]

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