Posted to microsoft.public.excel.misc
|
|
how do I calculate a difference in dates in years and months?
On Tue, 28 Oct 2008 10:01:02 -0700, Dan Cotts <Dan
wrote:
In the Help menu, I can see how to do it in years, and I can see how to do it
in months, but how do I do YY, MM? - I am trying to calculate retirment ages.
There is a basic problem in what you are trying to do, in that neither years,
nor months, are constant intervals. A year can be 365 or 366 days. And a
month can be 28,29,30 or 31 days.
There is a built-in function, DATEDIF, documented only in Excel 2000 or at
http://www.cpearson.com/excel/datedif.aspx, which will compute the differences.
But it has certain limitations when dealing with months that have different
lengths.
If that doesn't do what you require, or if its limitations are a problem, post
back with more specifics.
--ron
|