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?
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