Thread: Calculate number of months between dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
steph44haf steph44haf is offline
external usenet poster
  
Posts: 37
Default Calculate number of months between dates
B8 = 10/15/06
J3 = 09/30/07

The formula below computes 13 months, but I need it to calculate 12.5 months.

=(YEAR($J$3)-YEAR(B8))*12+MONTH(B8)-MONTH($J$3)

Does anyone know how I can calculate the 12.5 months?
Reply With QuoteReply With Quote