• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Elapsed time in months - Better Formula??

P

prasaddn

Active Member
In reference to Elapsed time in months

Per Chandoo...

To calculate the elapsed time in months, we can use the formula =(NOW()-A1)/30. This returns the value in 30 day months.


I use to apply formula =ROUND((TODAY()-A1)/30,0). Today, I faced a peculiar situation, A1 has date 01-Mar-2009, and today being 01-Mar-2012, it should be 36 months, but it is showing 37 months!!


Any suggestions to avoid such errors?


Even if i dont put round(), it is 36.56, can a formula be to show exactly 36?


Regards,

Prasad DN

PS: I rememeber some function in older version of xl like datediff(), but it is now not supported I guess.
 
Thank you OldChippy, This is exactly the same function I was looking for. I was using wrong spelling :)


Regards,

Prasad DN
 
Hi, prasaddn!

At risk of becoming repetitive I recommend you to read this posts:

http://chandoo.org/forums/topic/calculation-of-of-months-between-end-of-year-and-a-given-inputted-date

http://chandoo.org/forums/topic/excel-2007

Second is the original (with a smart -I think- bypass alternative), first the most recent that refers to it.

Feel free to make any questions.

Regards!
 
You must log in or register to reply here.
Back
Top