longevity dates
Hi Pam:
=DATEDIF(A1,A2,"y")&" years, "&DATEDIF(A1,A2,"ym")&" months" will yield: 20 years, 11 months -- Gary's Student "Pam Coleman" wrote: I have personnel records and I want to calculate longevity: begin date: 1/15/1985 and ending date 12/31/2005. What is the formula that will calculate the total years and months. Thanks, |
All times are GMT +1. The time now is 04:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com