Is it possible to have a cell updated with the balance of an account for a specific date? E.g., last date of each month

I’d like each row that represents an account of mine to be updated with the balance driven by the date of each column. I.e., every column represents the last day of the month.

This is similar to how the Net Worth Tracker template in Tiller Community Solutions works. The queries are non-trivial but if you poke around in there you can pull out what you need.