Datevalue comes back as #value

[elloco240866_Alsdorf]

Dear Forum,

In cell S2 I place a date.

In cell T2 I have this formula =IF(S2="";"";(S2+30))

In Cell U2 I have this formula and this gives #Value =IF(T2<TODAY();"";T2+30)

What am I doing wrong

[popipipo]

Same question
Same answer

http://www.excelforum.com/excel-form...197-value.html

[zbor]

@popipipo, you shouldn't ignore title change request there.


@elloco240866_Alsdorf , Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.