View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How to determine the number of months between 2 periods?

Eric,

Isn't it simply

=DATEDIF(A1,B1,"m")
with A1 as the earlier date

Mike

"Eric" wrote:

Does anyone have any suggestions on how to determine the number of months
between 2 periods? such as
01 May, 2006 and 01 Jun, 2007, there is 13 months between 2 periods,
The default day for each period is 1 of each month.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric