I want to 1) get a current balance in an account and 2) get a balance of that account on any defined date. I'm using SUMIFS. The only way I can get it to work is if I manually enter the date. Users need to be able to see current balance without entering anything. SUMIFS should work with the TODAY() function, but it won't if I link it to another cell or whenever I use the < or <=.
Spreadsheet attached. On the Funds Available worksheet, I have identified in green what I want to work.