Forum Discussion
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 ...
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
Or use a more precise value for month length: 365,2425/12 = 30,354166666