How to set minus value to 0
Replace the formula in D1 with new one!
Btw, there was a typo in my formula - the right one for D1 is
=IF(C1B1,0,DATEDIF(B1,C1,"m")
Datedif function with parameter "m" returns the difference between 2 dates
in full months.
--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )
"TSK" wrote in message
...
Hi Arvi,
Sorry, I think my explaination is still not clear.
Cell D is where I want the result to appear.
|