How about simply using cells for the dates, and then in a third use

=B1-A1

or whatever you choose.

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Ant" wrote in message
...
I want to run a quick macro to tell me the number of days between 2 dates.
I
was wondering if a user form my be the best way. I would like to assign a
button to a macro which then displays a User Form box where I can enter 2
dates into 2 text boxes or perhaps select from a data validation. A 3rd
text
box will tell me the number of days in between the 1st 2 dates. Does this
sound like I'm going in the right direction? If so, does someone know how
I
can do this. Thanks in advance, Ant.