Need formula to calculate duration between 2 dates.

January 14, 2013 at 08:27:48
Specs: Windows 7

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.


See More: Need formula to calculate duration between 2 dates.

Report •


#1
January 14, 2013 at 08:58:53

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 = .677

What accuracy are you trying to achieve?

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


Report •
Related Solutions


Ask Question