Referring to a Previous Day

Options

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.

Tags:

Answers