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,

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()