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

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