[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Trading Day of the Month



PureBytes Links

Trading Reference Links

Anybody have a formula that returns the Trading Day of the Month?
Even something that returns True for the 1st trading day of the month would
be OK.
I've tried putting something together but holidays seem to be a problem.

If(DayOfMonth() = 1, TRUE, If(DayOfMonth()=2 AND (DayOfWeek()=1 OR
Month()=1), TRUE, If( DayOfMonth()=3 AND DayOfWeek()=1, TRUE, FALSE)))

Many thanks,
Sean