Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Sat, 18 May 2024 17:04:04 +0000

How to Post a Message for Support

Post From: Spreadsheet study formula

[2015-02-15 22:01:11]
[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.