close
How can I calculate or know the exact age(Number of years) between two dates
Use DATEDIF():
if A1 and A2 contain:
1/15/1985
12/31/2005
then:
=DATEDIF(A1,A2,quot;yquot;) amp; quot; years, quot; amp; DATEDIF(A1,A2,quot;ymquot;) amp; quot; months, quot; amp;
DATEDIF(A1,A2,quot;mdquot;) amp; quot; daysquot;
will display:
20 years, 11 months, 16 days
--
Gary's Studentquot;AJAY KUMAR DIXITquot; wrote:
gt; How can I calculate or know the exact age(Number of years) between two dates
=DATEDIF(A1,B1,quot;yquot;)
HTH
--
AP
quot;AJAY KUMAR DIXITquot; lt;AJAY KUMAR gt; a écrit dans
le message de news: ...
gt; How can I calculate or know the exact age(Number of years) between two
gt; dates
全站熱搜
留言列表
