My on-going problems with dates
 

OK,
Trying another aproach.
Textbox4.text = Date (23 March 2007)
Textbox11.value = 2
Whay does this code:
Range("D2").Text = DateAdd("y", TextBox11.Value, TextBox4.Text)

NOT ADD Years(Textbox11.value = "2") ?
It ADD's 2 Days to the date instead ???


Corey....

My on-going problems with dates
 

Don't use this. y = Day of year, not years
Mydate = DateAdd("y", 2, "23 March 2007")
Use this instead to add two years.
Mydate = DateAdd("yyyy", 2, "23 March 2007")

"Coza" wrote:

OK,
Trying another aproach.
Textbox4.text = Date (23 March 2007)
Textbox11.value = 2
Whay does this code:
Range("D2").Text = DateAdd("y", TextBox11.Value, TextBox4.Text)

NOT ADD Years(Textbox11.value = "2") ?
It ADD's 2 Days to the date instead ???


Corey....