# adding months to a date

#### JPPROGRAMER

##### New Member
I have a date of 7/20/98 in cell A1 and I would like to add 8.6 months to that date. What is the best way to do this? Using the formula =MIN(DATE(YEAR(A1),MONTH(A1)+8.6+{1,0},DAY(A1)*{0,1})) only adds 8 months to cell A1 not 8.6 months?

### Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Just checking -- is 8.6 months a shorthand for 8 months and 6 days, or actually the decimal fraction of a month?

Denis

Denis,

.06 is the fraction of the month

Try this:
Date in B2, interval in C2, then this formula:
=IF(MOD(C2,1)=0,EDATE(B2,C2),EDATE(B2,C2)+MOD(C2,1)*30)

You'll need the Analysis ToolPak (Tools | Add-Ins) to use EDATE

Assumes a 30-day month

Denis

Thanks I'll give it a try

Works great thanks

Replies
2
Views
173
Replies
32
Views
640
Replies
1
Views
227
Replies
3
Views
133
Replies
1
Views
58

1,203,097
Messages
6,053,519
Members
444,669
Latest member
Renarian

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