View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default 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.