How do I add a date value to a cell?

C

cherez_nebo2021-08-11 13:54:25

Google Sheets

cherez_nebo, 2021-08-11 13:54:25

All the good time of the day. Such task: There is a report which is filled in daily
I want that from this report value of yesterday was transferred to other page. How to do it? Working on google spreadsheet

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Akina, 2021-08-11
@cherez_nebo

Formulas:

G1=TODAY()-1
G5:I5=VLOOKUP($G$1;$A$2:$D$11;COLUMN()-5;0)

The same if the target table is on another sheet: