View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Calculate Complete Months Between Two Dates

On Tue, 28 Oct 2008 15:04:05 -0700, Sheeloo <="to" & CHAR(95) & "sheeloo" &
CHAR(64) & "hotmail.com" wrote:

Try
=IF(DATEDIF(A1,B1,"m")1,DATEDIF(A1,B1,"m")-1,0)



A1: 1-Feb
B1: 1-Mar

-- 0

I think it should be one, as should 1-Feb -- 29-Feb
--ron