--- In [email protected], "Kusnady" <saw...@...> wrote: > > 77 trading days ahead from Today...means around next three month excluding > Friday, Saturday and Sunday....
A question: how can we know what trading days will occur in the future? It is not the same thing as a standard calendar since different regions can have different trading days. If we just go with 77 calendar days ahead excluding Friday, Saturday and Sunday then you should be able to get that using VBScript's DateAdd ( http://msdn.microsoft.com/en-us/library/cb7z8yf9%28VS.85%29.aspx ) and AFL Scripting Host. But then you'll still need to exclude Fri., Sat. and Sun. and determine the "rounding rules". If you land on a Friday does that mean your date will be Thursday or Monday? And if you really want to exclude Holidays then you will have to store those dates somewhere and then exclude those dates as well. Tuzo
