i need a fuction
 

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?
--
eng.amaal titi

i need a fuction
 

=MAX(0,(L1-C1-6)

L1 is latest data
C1 is oldest date

and copy down

Your formula was attempting to subtract a whole column (C:C:) from another
column (L:L)

"amaal titi" wrote:

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?
--
eng.amaal titi