Support Board

Date/Time: Sun, 22 Dec 2024 11:29:46 +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.