Thanks guys.....

CDate was the "key" that I was missing.
Brain fart, I guess?

Thanks again,
John

"Bob Phillips" wrote in message
...
Textbox3.Text = CDate(Textbox2.Text) - CDate(Textbox1.Text)

will give you 8. You can work out how to turn that into weeks and days,
especially as you get 9?

--

HTH

RP

"John Wilson" wrote in message
...
Anyone have an idea how to do the following:

On a UserForm.
TextBox1 = 9/20/04
TextBox2 = 9/28/04

Once the date is entered into TextBox2, TextBox 3 should populate with:
"1 week & 2 days"

Thanks,
John