I want yesterdays ad spend in my google sheet, and I want to add the timestamp as well. I figured out how get today in there, but is there a way to subtract 1 day from it so I get yesterday? [Screenshot 2023-12-21 at 13.24.55]

Hi @JesseH Please use the below formula {{formatDate(addDays(now; -1); “YYYY-MM-DD”)}} [image] If you require additional assistance, please don’t hesitate to reach out to us. MSquare Support Visit us here Youtube Channel

Get yesterdays date into sheet

How To

Msquare_Automation December 21, 2023, 12:34pm 2

Hi @JesseH

Please use the below formula
{{formatDate(addDays(now; -1); “YYYY-MM-DD”)}}

If you require additional assistance, please don’t hesitate to reach out to us.
MSquare Support
Visit us here
Youtube Channel

4 Likes

Topic		Replies	Views
How to get all records from Google Sheet for Yesterday? How To date-time-functions , google-sheets	2	457	April 1, 2024
Check the date from yesterday in Google sheet file How To google-sheets	3	309	April 24, 2024
Date time parameters to check google sheets vs current time How To filters , mapping , google-sheets	4	722	March 12, 2024
Adding a timestamp dd/mm/yyy How To	7	1940	December 7, 2023
How to get current date? How To date-time-functions	3	8736	October 24, 2023

Get yesterdays date into sheet

Related topics