There is no single formula that is appropriate for determining the period
between two dates in all situations. This is because the neither number of
days in a year nor the number of days in a month is constant. For some
purposes, such as determining a person's age, it may be appropriate to ignore
the effects of a leap year. For other purposes, the extra day in a leap year
may be important.

Consequently, you have to determine the purpose of your calculation and the
logic that supports that purpose before you design your formula (or write
your custom function using VBA). For example, if you were calculating the
period from February 28, 2005 to March 31, 2006, the correct answer might be
(a) 1 year, 1 month and 3 days, or (b) 1 year and 1 month, or (c) 365 + 31
days = 1.0849 years, depending on the purpose of the calculation. Each of
these possibilities would result in a different formula.

Depen
"Lyle" wrote:

Hello. I am fairly familiar with Excel and have been racking my brain trying
to figure a formula out. Here is the scenario. The military uses dates in
this order yyyymmdd ( i.e. 20050401 is April 1, 2005). I have two colums of
data in this fomat and I want to subtract one from the other to give me
atleast a total number of months and years. For example 19971015 minus
19600212. The long hand answer is 37y08m03d. I have 3190 of these I must
compute. Any help out there?
--
Lyle