Schuyler
New Member
Hiya,
I'm trying to project growth figures for my company over two years. I know where we are and I know where I want to get to, but I am struggling to work out a formula to calculate monthly targets over 24 months.
Current Yr: 382,135
In 2 yrs: 860,426
Monthly targets: ?
Can anyone help please?
I've attached an example. cell A4 is where we are, Z4 is where we want to get to, and in between are the monthly targets I want to fill out.
I'm trying to project growth figures for my company over two years. I know where we are and I know where I want to get to, but I am struggling to work out a formula to calculate monthly targets over 24 months.
Current Yr: 382,135
In 2 yrs: 860,426
Monthly targets: ?
Can anyone help please?
I've attached an example. cell A4 is where we are, Z4 is where we want to get to, and in between are the monthly targets I want to fill out.
Attachments

15 KB Views: 26