Hi Arvi,
Sorry, I think my explaination is still not clear.
Cell D is where I want the result to appear.
Appearance, the formula in cell D I insert
(YEAR(B1)-YEAR(C1))*12+MONTH(B1)-MONTH(C1) to calculate the month different.
I do not have any problem if it is positive but I am facing some calculation
problem when it is negative therefore I would liked excel to automatically
change the negative number to zero and recongize it as number zero too.
Base on the example quoted, the result should be -38 but I would liked the
-38 to change to zero in value. Hoewever, excel should also reflect the
actual different in number when the result is not negative
Example
B1 - 01 Mar 2009
C1 - 01 May 2008
D1 - (YEAR(B1)-YEAR(C1))*12+MONTH(B1)-MONTH(C1) = 10
Thank You