I would like to start trading a specified number of days before or after a certain date...how would I do this?

Dim Val

Dim Delay

Delay = -10

val = DateSerial(87,05,05) + delay

 

 

 

 

I am assuming calendar days or trading days, also what do you do if the date you pick is a non trading day, saturday or sunday.

 

 Depending on the answers to these questions things are different.

val = DateSerial(year, month, day)

+delay 

should work  to get you a valid serial date , but it might not be a trading day.

How are you using this date ?.

In print , comparing to another date ?.

 

If possible to offset X number of business days is the best option....how would I do that?