Support Board
Date/Time: Thu, 18 Dec 2025 00:02:29 +0000
Post From: Spreadsheet study formula
| [2015-02-16 00:49:59] |
| Sawtooth - Posts: 4299 |
|
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
|
