At least post your formulas. You may want to use if(day(rng

On Jan 25, 4:27*am, rhhince wrote:
I have a whole column of dates and time. I am trying to screen out
Fridays and 20:00 to prevent trading at that hour. I have formulas
that trade every 20:00 during the week including Friday at that time.
I simply can't get the formula to screen it out. Any help would be
appreciated. Thanks.

Fri * * 1/20/2012 * * * 19:00 * 0.9342 *0.9349 *0.9339 *0.9347 *1088 * * * * * *44.24 * 40.84
41.56 * * * * * 0
Fri * * 1/20/2012 * * * 20:00 * 0.9348 *0.9356 *0.9345 *0.9352 *1147 * * * * * *47.25 * 42.44
41.28
Fri * * 1/20/2012 * * * 21:00 * 0.9353 *0.9353 *0.9340 *0.9341 *722 * * * * * * 45.73 * 44.12
41.90 * * * * * 0