Date Addition

how to add 7 days from today date

assume: txtStartdate, txtEndDate are TextBox

txtEndDate.Value = DateValue(txtStartDate.Value) + 7

You can further format it e.g. 20-Apr-09

Format(txtEndDate.Value, “dd-mmm-yy”)