Support Board
Date/Time: Sun, 06 Jul 2025 07:29:27 +0000
Post From: Offset formula in spreadsheet
[2024-04-30 22:09:16] |
Sawtooth - Posts: 4235 |
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)) |