Support Board

Date/Time: Sat, 01 Nov 2025 11:33:57 +0000

Post From: Spreadsheet study formula

[2015-02-15 22:01:11] Link To Thread - Link To Post [Go To First Post]
User48557 - Posts: 138
=IF(AND(WEEKDAY(A3)=1,A4-INT(A4)<TIMEVALUE("17:00:00"),A3-INT(A3)>=TIMEVALUE("17:00:00")),B3,K4) That formula is for a horizontal line that starts every Sunday open. I'd like to know if there is a similar formula for Fridays closing price. I'd like the horizontal line to start on Friday's close and be drawn up to next Fridays close.