Showing the months between 2 date fields

[Excel-Guru-1987]

Hey Guys,

Not sure if this is possible but is there a way to show all of the months between 2 date fields?

[shukla.ankur281190]

Assuming you have dates in A1 & B1

tRY

=MONTH(b2)-MONTH(a1)

[Excel-Guru-1987]

I can get the value easy enough what i am trying to do is display all the months for example.

Start Date = 01/10/2016
End Date = 01/02/2017

Result would be

01/10/2016
01/11/2016
01/12/2016
01/01/2017
01/02/2017

Now i know i cannot put this into a single cell but trying to think of possible ideas outside the box.

Basically the start date will have a currency value assoicated with it which i am trying to show the value over the period of time between the 2 dates in form of a chart.

Is that possible or am i going about it all the wrong way?

[Phuocam]

Start Date in A1.

End Date in A2.

Try this formulas in A3:

=IF(EDATE($A$1,ROWS($A$3:A3)-1)>$A$2,"",EDATE($A$1,ROWS($A$3:A3)-1))

Copy down.

[Excel-Guru-1987]

H'mmm that works was not expecting that.

The next issue i have is using this method try to apply it to how i want it to work.

Any suggestions?

[AliGW]

How do you want it to work?

[Excel-Guru-1987]

Hi Ali,

I think I may have drifted slightly off topic as the original request has actually been dealt with but doesn't actually deal with the current issue I am experiencing.

I have a sheet of data currently with a start date an end date with a monthly currency value. I am trying to see if there was a way of excel identifying the months between the two dates which Phuocam has answered on how to do that with the above post.

The issue is how do I enforce this when I am dealing with multiple rows of data each with all different start and end dates in a worksheet.

The end result is for me to display this in terms of a piovt chart but I am not too sure if I can manipulate the data set in this way.

The more and more I think about it the more am coming to grips that it cannot be done that way.

I am currently working on an alternative solution to my issue which is just to display the next 6 months inside a table but haven't quite perfected the formula to do that yet.

[AliGW]

Maybe if you attach a sample workbook?

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.