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

Google Sheets
1

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.

2

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.

3

Hi @randy -

I realize this was posted years ago, but it’s exactly what I’m looking to do.

Could you share a specific example of how to create a custom sheet like below?

I reviewed the formulas in the Net Worth Tracker, but couldn’t infer how to do it from those.

Account Name Jan Feb Etc.
Account1 BalanceEndOfJanuary BalanceEndOfFebrurary Etc.
Account2 BalanceEndOfJanuary BalanceEndOfFebrurary Etc.
AccountN BalanceEndOfJanuary BalanceEndOfFebrurary Etc.

4

@AutomationNation see my response in the new thread you created: