Re: $$Excel-Macros$$ Help for date formula

2014-08-12 Thread Paul Schreiner
u can, To all the people you can, As long as ever you can.” - John Wesley - From: Shrinivas Shevde >To: excel-macros@googlegroups.com >Sent: Monday, August 11, 2014 6:24 AM >Subject: $$Excel-Macros$$ Help for date formula > > > >I w

Re: $$Excel-Macros$$ Help for date formula

2014-08-11 Thread Vaibhav Joshi
Hi Use datedif formula: =DATEDIF(A1,A2,"m") where a1 contains oldest date. Cheers!! On Mon, Aug 11, 2014 at 3:54 PM, Shrinivas Shevde wrote: > I wish to find out difference between two dates in terms of Months. > > > > e.g. 10th May 2014 & today = 3 months > > 10th May 1993 & today = 255 mo

Re: $$Excel-Macros$$ Help for date formula

2014-08-11 Thread Ashish Kumar
Hi Srinivas, PFA...!! Regards Ashish On 11 August 2014 15:54, Shrinivas Shevde wrote: > I wish to find out difference between two dates in terms of Months. > > > > e.g. 10th May 2014 & today = 3 months > > 10th May 1993 & today = 255 months > > 10th jan 1981 & today = 403 months > > > --

$$Excel-Macros$$ Help for date formula

2014-08-11 Thread Shrinivas Shevde
I wish to find out difference between two dates in terms of Months. e.g. 10th May 2014 & today = 3 months 10th May 1993 & today = 255 months 10th jan 1981 & today = 403 months -- Shrini -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Joi