i need a fuction

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
=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)
 
Back
Top