how can months calculated betwwen two dates
Posted by gokhan on December 06, 2001 11:49 PM
for example 3/may/97 and 25/12/2001 how many months is there between this dates.
Please different solution than finding the days and then dividing it to 30.
Posted by Aladin Akyurek on December 07, 2001 12:08 AM
Gokhan --
DATEDIF might fit what you want:
=DATEDIF(A1,B1,"M")
where the date in A1 must be earlier in time than the date in B1.
Aladin
========
Posted by gokhan on December 07, 2001 12:46 AM
thank you again aladdin. It works well. Strange in my help menu this function does not exist so i havent learn about it.
