View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default Completed Months between Dates

On Sun, 25 Jan 2009 09:36:23 -0000, "David Biddulph" <groups [at]
biddulph.org.uk wrote:

=DATEDIF(A1,A2,"m") would give the number of completed months, which would
be 8, not 7.



I guess the OP wanted the number of complete, not completeD, months,
i.e. number of complete months excluding the months of start and end
rather than the time difference measured in a month scale.

Lars-Åke