| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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.... |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Between dates. Two problems | Excel Discussion (Misc queries) | |||
| My on-going problems with dates | Excel Programming | |||
| Problems with dates? | Excel Discussion (Misc queries) | |||
| problems with dates | Excel Discussion (Misc queries) | |||
| problems with dates before 1900 | Excel Programming | |||
Linear Mode
