Formula to get a value of a field from a record that is one month older than another record

I have a table in our CRM that keeps track of what clients are spending. Every day a copy of all of the client information including the spend is saved to that table (copies all field values from `Cli...