Referring to a Previous Day

Psilano

Can someone please assist in helping with a formula that will simply just refer to a value from a previous date? Example: Two Rows by two Columns. The top row has a date of 4/3/22 and in the Value Column it has 5. In the bottom row the date is 4/4/22 and in the Value Column it has a 3. If I wanted to add the two values together, how can I call upon the previous day's Value.

Paul Newcome

Try something like this...

=[Value Column]@row + INDEX([Value Column]:[Value Column], MATCH([Date Column]@row - 1, [Date Column]:[Date Column], 0))

Psilano

Thank you very much Paul.

Paul Newcome

Happy to help. 👍️