Finding the "Next" Date

[Sarah]

I need to develop some code that will respond with a "Next" date - so, today
could be Tuesday, the user clicks on a drop-down to ask for the date of any
one of the following:

- Next Friday
- Two-weeks Friday
- Next Wednesday
- Two-weeks Friday

Whatever the user selects, I need to provide a response that gives the date
(i.e. July 23, 2003) that they requested. What type of functions are able to
do this? Is a custom function needed?

 

[Allen Browne]

Date()
Weekday()
DateAdd()

The optional 2nd argument of Weekday() can be useful for calcuating from
specific days.