Support Board

Date/Time: Sun, 22 Dec 2024 11:00:30 +0000

Post From: Spreadsheet study formula

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