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.
