G
Guest
i would be grateful if any one can help with this...i am making a function to
subtract between two dates(date - date1) and then subtract from 6 if it is
less than 0 then true 0 if other wise then the function (date-date1)-6
=((if(L:L-C:C)-6<0,0,(L:L-C:C)-6) this is the funtion but it gives wrong?
subtract between two dates(date - date1) and then subtract from 6 if it is
less than 0 then true 0 if other wise then the function (date-date1)-6
=((if(L:L-C:C)-6<0,0,(L:L-C:C)-6) this is the funtion but it gives wrong?