adding numbers from different fields to date

Hello
i have a form with 4 text box. TB1 to TB4. TB1 and TB2 accept numbers and TB3 is the start date TB4 is end date i.e. TB1 + TB2 + TB3.
i am not able add TB1 and TB2 it concatenating them i.e. if i enter 1 in TB1 and 1 in TB2 it should add 2 to TB3 but it is adding 11.

Please Login or Register  to view this content.

i even tried
- ExtraDays = val(TB1 + TB2)
- ExtraDays = CInt(TB1 + TB2)
none of these work it adds 11 instead of 2

i have posted this on https://www.mrexcel.com/forum/excel-...elds-date.html too.

Without all the extra plumbing, wouldn't it simply be:

Please Login or Register  to view this content.