Support Board
Date/Time: Sat, 08 Nov 2025 13:06:47 +0000
Post From: Offset formula in spreadsheet
| [2024-04-30 22:09:16] |
| Sawtooth - Posts: 4287 |
|
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)) |