How do you create a formula that will calculate/prorate a field over a timeframe?

Looking into how to create a formula that could calculate/prorate a field over a time frame if record crosses over multiple months or even last year to this year. Example: columns in data model unde...