adding months to a date

[JPPROGRAMER]

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?

 

[SydneyGeek]

Just checking -- is 8.6 months a shorthand for 8 months and 6 days, or actually the decimal fraction of a month?

Denis

 

[JPPROGRAMER]

Denis,

.06 is the fraction of the month

 

[SydneyGeek]

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

 

[JPPROGRAMER]

Thanks I'll give it a try

 

[JPPROGRAMER]

Works great thanks