# How do you use month formulas

#### JessJacques

##### New Member
Hi All,

Maybe someone can help me. I know this is probably really simple, that is probably why I can not figure it out. Here is my issue.

This is in regards to trying to figure out how many months are left before hitting a deductable. So if I my client is spending \$112 per month, which is \$1334 per year, and they have to hit \$2250 deductable before they have to pay retail. I need to figure out how many months this will take them until this happens. My formula comes out to 20 months, so I have to have the formula revert automatically to 12, since that is how many months are in a year. So I have \$2250/112 = 20, I need this to go to 12 by default. Can anyone help me with this. I would greatly appreciate it because I am stumpt.

### Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

##### MrExcel MVP
perhaps:

min(round(a1,b1),12)

#### JessJacques

##### New Member
Thank you so much. That worked......

Replies
11
Views
190
Replies
5
Views
195
Replies
1
Views
274
Replies
8
Views
351
Replies
9
Views
383

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,163,632
Messages
5,832,772
Members
430,166
Latest member
Nige Leeming

### 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.

### Which adblocker are you using?

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

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