help fix dateadd into ditpicker on userform

[ABDELFATTA]

hi, all

i need help about account date by dateadd into textbox on userform i have two datepicker when i add days and months and years to dtpicker1 it should show a new date in dtpicker2 so dtpicker1 based on textbox3,4,5 after write first data and end date then account old the problem it gives me wrong a new date for instance first date=15/05/2010 end date= 1/1/2011 days=231 months=8 years=1
a new date in dtpicker1 = 11/04/2020 it gives me this data in a new date datpicker=11/04/2021 it supposes = 28/12/2021 but it gives me wrong date an error by the way i crossed post in this forum nobody answers me so far
https://www.mrexcel.com/board/thread...rform.1134989/

and this is my code about dateadd

[oeldere]

Duplicated post.

Please also mark the other question, which is unansered as solved.

[ABDELFATTA]

what you mean Duplicated post. i don't issue the same post in earlier if you mean i issued this question before and if you mean somebody issued the same topic i will change it

[torachan]

The reason you are seeing what you believe to be the wrong date is because you are overwriting the datediff.
datediff does not enable you to write individual days - months -years you will have to do one only.
I have blanked out your datediff month & year, you will see if you allow only days it is accurate, then blank datediff days and try months by itself that works and so does years.
Although I fail to see the point of the excercise

[ABDELFATTA]

hi, torchan i know this way you're right about choose one case day or month or year then gives me right value but i search code do that together and you misunderstood it supposes showing the result in dtpicker2 after choose the date from dtpicker1

[ABDELFATTA]

any help please

[ABDELFATTA]

no answering so far

[ABDELFATTA]

it solved by this forum
https://www.mrexcel.com/board/thread...1134989/page-5