# Need One formula to Auto Calculate - for 12 Months

#### duffy0626

##### New Member
 Contract Monthly Fee One Time Fee Start Date End Date Jan Feb Mar Apr May June July Example 1 1,000 500 02/16/14 07/24/14 928.57 1000 1000 1000 1000 774.19

<tbody>
</tbody>
I need help with one formula that I can copy over to calculate what I already have in the month columns. Basically, February - started on the 16th, so \$1,000 divided by 28 days, Times 12 Days, plus the one time fee. July - billed for only 24 days. One formula will help since there are multiple rows of contracts. Thanks!

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
Awesome, thanks!

You're welcome.

Replies
1
Views
721
Replies
6
Views
361
Replies
14
Views
745
Replies
1
Views
171
Replies
1
Views
827

Threads
1,196,308
Messages
6,014,583
Members
441,828
Latest member
cofracr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back