Start with

Textbox2.Text = Format(cdate(TextBox1.Tex)t + 1, "dd mmm yyyy")
etc.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sarah" wrote in message
...
Hi,

I'm creating a chart in an excel form and it has the same section 7 times
(for every day of the week)

I want it so that once the user enters the first date for Sunday. eg they
enter: 12/12/04, then all the other date fields for the rest of the week
get
filled in automatically. So the date field for that Monday will be
12/13/04...

Is this possible?!?! If yes, how!