How to subtract two date Problem
Try,
=MONTH(B1)-MONTH(A1)
Format as general.
Mike
"ghost" wrote:
Hi
I have a sheet to calculate the number of months between to date.
in A1 = 05/26/2007
B1 =06/26/2006
C1 = =DATEVALUE (B1-A1)
After that C1 shows me €śvalue€ť which is an error
Can any body help me solving this problem?
Thanks!!
|