Date in an excel form
woweeeeeeeeee you're a genius! :)
thanks!! :D
"Bob Phillips" wrote:
Okay, let's say that the Sun date is in A1. In the Mon date cell, input the
formula =A1+1. In the Tue date cell, input the formula =cell+1 where cell is
the Mon date cell. etc.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Sarah" wrote in message
...
ooooooops sorry ..
I'm just using a spreadsheet, the date is just being entered into an excel
CELL and so, the user will enter the first date for the sunday of the
week,
and then i want it to automatically fill in the dates for the rest of the
week (mon-sat)
please help! :) thank you! :)
"Bob Phillips" wrote:
Sarah,
You said it was in a form, so I took some licence and assumed that you
would
have the dates in textboxes. Re-reading your post, I don't think you
actually mean a form, so where will you store these dates, and how will
the
series be started.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Sarah" wrote in message
...
I am trying this, I'm not sure where I'm supposed to put this line of
code
in
I put it in the workbook_open
Private Sub Workbook_Open()
Sheet1.TextBox2.Text = Format((CDate(TextBox1.Text) + 1), "dd mm
yyyy")
End Sub
but I'm getting an error!
Help!?!!!
"Bob Phillips" wrote:
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!
|