Login Page - Create Account

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