View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default Help with date formula

I need to calculate the difference in months between 01 October 2007 and 31
December 2007. When i am using the following formula
=MONTH(B3)-MONTH(B2)
i am getting a result of 2 although it should be 3....any ideas...help please