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
|