Read Help on the date functions. The best data entry method is to use one of
the date controls like DatePicker or Calendar, which is guaranteed to return
a valid date; next best is to let the user enter the date as a string then
use CDate() or DateValue() to convert it then display the converted value
back to the user. The conversions in both directions should use the user's
own regional settings rather than assuming m/dd/yy (as you seem inclined to
do -- *most* of the world does not use that format).
To calculate another date from a given date you can use the DateAdd()
function; or if you are dealing with simple day offsets you can just
add/subtract. (And forget about integers. Internally, dates are doubles.)
>I was going to use an input box to ask the user for a date but I'm not sure
> the type of object it should be. I don't want it as a String because I
[quoted text clipped - 8 lines]
> Stumped,
> Charlie
Kevin B - 30 Jan 2006 13:43 GMT
I you go the Input Box route, in addition to the aforementioned formula
functions (CDate(), DateValue()) you can use the IsDate() function to
determine if the entry can be read as a vaild date.

Signature
Kevin Backmann
> Read Help on the date functions. The best data entry method is to use one of
> the date controls like DatePicker or Calendar, which is guaranteed to return
[quoted text clipped - 20 lines]
> > Stumped,
> > Charlie
Jezebel - 30 Jan 2006 21:00 GMT
IsDate() has a rather poor reputation. The function returns true for times
as well as dates, so it accepts entries like "23:59:59" and "1.1.1" -- on
the other hand it rejects legitimate foreign language dates like "4 Enero
2006".
>I you go the Input Box route, in addition to the aforementioned formula
> functions (CDate(), DateValue()) you can use the IsDate() function to
[quoted text clipped - 32 lines]
>> > Stumped,
>> > Charlie