View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Livingstone Mark Livingstone is offline
external usenet poster
 
Posts: 4
Default How calculate exact # of months between two dates?

Hi,

Right now I am using the DATEDIF(CELL1, CELL2, "m") function. However,
it provides only single digit response. So, if the two dates are 20
JUNE and 20 SEPTEMBER, it will be 2 months. However, if the two dates
are 20 JUNE and 20 SEPTEMBER, it give me 1 month instead of 1 month
and X days (or, 1.x << this is exactly output that I am trying to
achieve)

Any idea how to do that? Excel 2003.

Thanks!