Date calculation question

[tigger2]

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.

 

[boxsterman]

What are you getting as a response in your formula?

 

[north19701]

=IF(H11=0,TODAY()-L11,J11)

is this what you're looking for?

 

[tigger2]

That works - thanks. I see I didn't have the () with TODAY.

Thanks again.

 

[gaynard_nelson]

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.

This works for me. If
H11=15
J11=30
L11=3/1/2004

Then this formula displays

30 as the answer

=IF(H11=0,TODAY()-L11,J11)

Excel will try to format this formulas cell as a date, since it is working with cells that have dates in them. You need to format this formulas cell for General, so it will display the answer in days.