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