I am trying to use a date function in a formula and not sure what I'm doing wrong:
=IF(H11=0,DATE(2004,1,31)-L11,J11)
BAsically the formula says if H11 (response date) is 0, calculate the number of days between today and the due date; otherwise use the value of H11 - the response date.
I tried TODAY, NETWORKDAYS, DATE - I'm sure I"m missing an argument or something but am not very familiar with date functions.
Any ideas would be appreciated.
=IF(H11=0,DATE(2004,1,31)-L11,J11)
BAsically the formula says if H11 (response date) is 0, calculate the number of days between today and the due date; otherwise use the value of H11 - the response date.
I tried TODAY, NETWORKDAYS, DATE - I'm sure I"m missing an argument or something but am not very familiar with date functions.
Any ideas would be appreciated.