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 wish your email had an "undo send" feature?

Discuss in The Lounge

Poll History