close
Friends,
If I have two dates: February 5,1999 and January 4, 2002, how can I
calculate the number of months and days between both dates?
Thank you for your time.
shopgirl gt; wrote
gt; Friends,
gt; If I have two dates: February 5,1999 and January 4, 2002, how can I
gt; calculate the number of months and days between both dates?
gt; Thank you for your time.
With the first date in A1 and the second in B1
Try
=DATEDIF(A1,B1,quot;mquot;)amp; quot; months quot;amp;DATEDIF(A1,B1,quot;mdquot;)amp;quot; Daysquot;
For more information on the undocumented Datedif function go to
www.cpearson.com/excel/datedif.htm
--
Regards
Roger Govier
全站熱搜
留言列表
