View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jean Jean is offline
external usenet poster
 
Posts: 78
Default Number of Months and Days between 2 dates?

Hi is it possible to calculate the number of months and the remaining days
between 2 dates, i.e

Date 1 is 1/16/07
Date 2 is 6/10/07

So if I use the DatedIF(Date 1, Date 2,"M") i would have the # of months;
how would i have the days remaining, meaning i have 4 months, and 24 days,

help please !