Date question
in [Functions]
|
Prev: Function to seacrh for a word across multiple columns
Next: Store formulas in Vlookups? (another try ;)
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" <ziggy943(a)xmission.com> 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" <biffinp...(a)comcast.net> wrote: > Try this... > > A1 = 6/1/2003 > > =DATEDIF(A1,NOW(),"m") > > -- > Biff > Microsoft Excel MVP > > "Ziggy" <ziggy...(a)xmission.com> 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" <ziggy943(a)xmission.com> wrote in message news:5c82924d-e209-4a10-9536-b02eb0726f90(a)z6g2000yqz.googlegroups.com... On Apr 16, 2:44 pm, "T. Valko" <biffinp...(a)comcast.net> wrote: > Try this... > > A1 = 6/1/2003 > > =DATEDIF(A1,NOW(),"m") > > -- > Biff > Microsoft Excel MVP > > "Ziggy" <ziggy...(a)xmission.com> 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. |