From: Ziggy on 16 Apr 2010 16:22 Is there a simple formula that will give the difference between two dates in MONTHS? Today() - (6-1-2003) = MONTHS From: T. Valko on 16 Apr 2010 16:44 Try this... A1 = 6/1/2003 =DATEDIF(A1,NOW(),"m") -- Biff Microsoft Excel MVP "Ziggy" wrote in message news:40762e16-9a39-4906-8630-c1ffc5ed1e4d(a)i25g2000yqm.googlegroups.com...> Is there a simple formula that will give the difference between two > dates in MONTHS? > > Today() - (6-1-2003) = MONTHS From: Ziggy on 18 Apr 2010 01:58 On Apr 16, 2:44 pm, "T. Valko" wrote:> Try this... > > A1 = 6/1/2003 > > =DATEDIF(A1,NOW(),"m") > > -- > Biff > Microsoft Excel MVP > > "Ziggy" wrote in message > > news:40762e16-9a39-4906-8630-c1ffc5ed1e4d(a)i25g2000yqm.googlegroups.com... > > > > > Is there a simple formula that will give the difference between two > > dates in MONTHS? > > > Today() - (6-1-2003) = MONTHS- Hide quoted text - > > - Show quoted text - Thanks it worked great. I ended up using the YEARFRAC though as a better solution for my needs, But thank you very much. From: T. Valko on 18 Apr 2010 10:22 You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "Ziggy" wrote in message news:5c82924d-e209-4a10-9536-b02eb0726f90(a)z6g2000yqz.googlegroups.com... On Apr 16, 2:44 pm, "T. Valko" wrote:> Try this... > > A1 = 6/1/2003 > > =DATEDIF(A1,NOW(),"m") > > -- > Biff > Microsoft Excel MVP > > "Ziggy" wrote in message > > news:40762e16-9a39-4906-8630-c1ffc5ed1e4d(a)i25g2000yqm.googlegroups.com... > > > > > Is there a simple formula that will give the difference between two > > dates in MONTHS? > > > Today() - (6-1-2003) = MONTHS- Hide quoted text - > > - Show quoted text - Thanks it worked great. I ended up using the YEARFRAC though as a better solution for my needs, But thank you very much.