Support Board
Date/Time: Sat, 18 May 2024 17:04:07 +0000
Post From: Spreadsheet study formula
[2015-02-16 00:49:59] |
Sawtooth - Posts: 4000 |
Use 6 for Friday, edit the timevalue to Friday's final bar time, and change B3 to E3, e.g.: =IF(AND(WEEKDAY(A3)=6,A4-INT(A4)<TIMEVALUE("16:00:00"),A3-INT(A3)>=TIMEVALUE("16:00:00")),E3,K4) Date Time Of Last Edit: 2015-02-16 04:07:25
|