Dates Calc

  • Thread starter Thread starter chris
  • Start date Start date
C

chris

Hi,

I have a question. I would like to add dates to text
boxes based off an initial date entered.

For Ex.

Text 1 = Todays Date

calculation:
Textox 2 = + Two weeks from today(3-9-04 + 2weeks) which
would be (3-23-04)
Textbox 3 = + 2 weeks from 3-23-04
Textbox 4 = + 2 weeks .........
Textbox 5 = + 2 weeks .......
Textbox 6 = + 2 weeks .......
Textbox 7 = + 2 weeks .......
Textbox 8 = + 2 weeks .......
Textbox 9 = + 2 weeks .......
Textbox 10 = + 1 weeks .......
Textbox 11 = + 2 weeks .......
Textbox 12 = + 4 weeks .......

Thank you

chris
 
Textbox2.text = cdate(textbox1.text) + 14

etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Just add 14 to the data

Textbox2 = Format(DateValue(Textbox1) +14,"m-d-yy")

and so forth
 
Back
Top