Support Board

Date/Time: Sat, 10 May 2025 00:32:12 +0000

Post From: Spreadsheet study formula

[2015-02-16 00:49:59] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 4214
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