Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 26 Sep 2024 23:18:39 +0000

How to Post a Message for Support

Post From: Offset formula in spreadsheet

[2024-04-30 22:09:16]
[Go To First Post]
Sawtooth - Posts: 4092
I guess you need to include a day -1 variable but how can I do that ?
You'd need to use, e.g., cell X3 with this formula:
=IF(Y3=$Y$1-1,FRACTIME(A3),0)
then this formula in H8:
=MAX(INDEX(F$3:F$1002,MATCH($H$7,X$3:X$1002,-1),1):INDEX(F$3:F$1002,MATCH($H$6,X$3:X$1002,-1),1))