Automatically Generate a number of months between two dates

DatedIf(Start_Date,End_Date,Interval)

Formula:

Please Login or Register  to view this content.

Introduction To The DATEDIF Function

The DATEDIF function computes the difference between two dates in a variety of different intervals, such as the number of years, months, or days between the dates. This function is available in all versions of Excel since at least version 5/95, but is documented in the help file only for Excel 2000. For some reason, Microsoft has decided not to document this function in any other versions. DATEDIF is treated as the drunk cousin of the Formula family. Excel knows it lives a happy and useful life, but will not speak of it in polite conversation. Do not confuse the DATEDIF worksheet function with the DateDiff VBA function.

The syntax for DATEDIF is as follows:

=DATEDIF(Date1, Date2, Interval)

Where:
Date1 is the first date,
Date2 is the second date,
Interval is the interval type to return.

If Date1 is later than Date2, DATEDIF will return a #NUM! error. If either Date1 or Date2 is not a valid date, DATEDIF will return a #VALUE error.
The Interval value should be one of

Interval Meaning Description
m Months Complete calendar months between the dates.
d Days Number of days between the dates.
y Years Complete calendar years between the dates.
ym Months Excluding Years Complete calendar months between the dates as if they were of the same year.
yd Days Excluding Years Complete calendar days between the dates as if they were of the same year.
md Days Excluding Years And Months Complete calendar days between the dates as if they were of the same month and same year.

If Interval is not one of the items listed in above, DATEDIF will return a #NUM error.

If you are including the Interval string directly within the formula, you must enclose it in double quotes:

=DATEDIF(Date1,Date2,"m")

If you have the interval in another cell referenced by the formula, that cell should not have quotes around the interval string. For example, with the formula

=DATEDIF(Date1,Date2,A1)

cell A1 should contain m not "m".

Source:-

http://www.cpearson.com/excel/datedif.aspx

Hi TamHam. Welcome to the forum.

Do you mean output like this? With Start/End dates in A1:B1

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

1

1/15/2017

9/13/2018

January

February

March

April

May

June

July

August

September

October

November

December

welcome to the forum. do upload an excel sample so that we do not have to manually key in your data to do a testing.

input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand. post #4 from Dave is a good eg. but if it's ending in 13-Sep-2018, i suppose the months should keep repeating until it reaches sep again?

the upload attachment must be done by going to Go Advanced. click on Manage Attachments. Choose file, upload and close the window.

if i really guessed it wrongly, please upload something according to my recommendations. try to use the solution i have given and we'll help to advise what went wrong.

like your eg, i assume Start Date in A1 and End Date in A2. i don't know what's in C1 though. so say formula in D1:
=IF(EDATE($A$1,COLUMNS($D$1:D1)-1)>EOMONTH($A$2,0),"",EDATE($A$1,COLUMNS($D$1:D1)-1))