View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Counting months between two years

try =datedif(start_date, End_date,"m")
you won't find datedif in help but you will find alo if you google it.

"Sarah" wrote:

Hi, I am trying to be able to calculate how many months are between two
dates. I have been able to figure it out for going from a month at the
beginning of the year to a month later in the year.

[ex. 2/12/07 to 9/1/07 gives me 7, with =MONTH(B2)-MONTH(C2)]

But if i were to go from 9/1/07 to 2/12/08, it won't work.

Can anyone help me?
-Sarah