Sorry, I have to send it again, because it does not appear what I posted
originally.
1. In cell B2, I entered Jul-03 (cell is formatted mmm,yy) as Date In
2. In cell C2, I entered Jun-04 (cell is formatted mmm,yy) as Date Out
3. D2 is for "interval time" : I used formula -- datedif (C2,B2,"m")
And the result I got is "#NUM!".
How should I format Cell D2? Which step I went wrong?
Any help would be much appreciated.
LJ
|