I’m trying to add historical data older than what Tiller imports from my account and I saw this article showing “How to manually add weekly data”, but it only brings the following formula to Google Sheets:

Anyone knows the formula to do the same in excel? (I’d actually create the formula as I did for the “month”, but I couldn’t understand the logic being used for that column…)
Thanks

I guess I found the formula that is consistent with what I’m seeing in the values imported automatically. Assuming the date is in a column called “Date”. here’s what worked for me:

“Spill Ranges” are sort of the Excel equivalent of ARRAYFORMULA()…
… but someone please correct me if my terminology is wrong…

When I try to use a spill range inside the Transactions Excel table, I get this error:

The formula you typed could return multiple values which is not supported in tables.
Would you like to use the following formula instead? =[@Date]-WEEKDAY ([@Date],2)

Formulas within Excel tables are allowed which is the workaround… the down side is that the formula must be extended as rows are added.