Need formula to calculate duration between 2 dates in separate columns. For example: start date 10/20/2010 end date 4/13/2011. Need result in months. Also: start 1/20/2010 end 12/13/2011.

When you say you "need results in months" what exactly are you looking for? Depending on what you are looking for, the difference between 10/20/2010 and 4/13/2011 could be 5 months (rounded down), 6 months (rounded up) or ~5.8 months.

Getting an exact answer can be cumbersome because a month can have 28, 29, 30 or 31 days. So given something like 5 months and 21 days, what percentage of a month is 21 days?

21/28 = .750

21/29 = .724

21/30 = .700

21/31 = .677What accuracy are you trying to achieve?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll

Do you think people should be allowed to list their rented apartments on Airbnb?

Discuss in The Lounge

Poll History