#INVALID COLUMN VALUE Error with Max() Function
I'm was trying to use the Max() function to grab the latest date in a supporting sheet. From reading it looks like this is a valid use of the function. The sheet being referenced is set as a date field in properties.
I'm basically building a small sheet to feed the latest daily balances on some company bank accounts for the Finance team to use. Originally I tried building a report with the filter feature set to "In the Last (days)." However that didn't work too well on Mondays since the last entry would be a Friday (weekend no posting). So my second idea was to build a sheet that would pull the values I needed using the Max function to grab the latest date entry. However, as you can see below I'm getting an error message. Any ideas why I'm getting this error message or an alternative solution?
Figure 1 - Reference Sheet
Figure 2 - Error Message