Monthly Forcasting?

Not sure what term to search for but let me explain what I want to do.

I have a sheet with a bunch of data from this month, then another row with data from the previous month. In another column, I have my monthly goals that I set for this month. The issue is, I want to create another column that will show me where I should be at in terms for that particular day of the month.

For example, lets say last month I made $100, for February I've only made $30. In another column, I want to know what value I should be at in order to make my goals. Like you need to be at $32 in order to make you goals

See the attached sheet for more of an explanation.