Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Screening through days of the week including time
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Screening through days of the week including time
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Future date with six day week including holidays | Excel Worksheet Functions | |||
number of week days in a period of time | Excel Worksheet Functions | |||
Counting calendar Days - not including Sundays | Excel Discussion (Misc queries) | |||
How to add 30 days to date in another column, including Sat/Sun? | Excel Worksheet Functions | |||
Re Change 5 week days to 7 days in this formula | Excel Worksheet Functions |