close
Hi Pam:
=DATEDIF(A1,A2,quot;yquot;)amp;quot; years, quot;amp;DATEDIF(A1,A2,quot;ymquot;)amp;quot; monthsquot;
will yield:
20 years, 11 months
--
Gary's Studentquot;Pam Colemanquot; wrote:
gt; I have personnel records and I want to calculate longevity:
gt; begin date: 1/15/1985 and ending date 12/31/2005.
gt; What is the formula that will calculate the total years and months.
gt;
gt; Thanks,
全站熱搜