I'd use something like:
With the date to consider in A1, use:
=(YEAR(TODAY())-YEAR(A1))*12+MONTH(TODAY())-MONTH(A1)
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
T
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
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
>
>
> --
