Get Month Names Between 2 Dates.

Hi Kindly Advise me a solution.

I am able to get the Months count between 2 dates using "=Datedif(Startdate,Enddate,"m")

but I also need the names of the months & year in between 2 dates, like below pic, yellow highlighted is my requirement.

This may help....non-VBA.

https://www.mrexcel.com/forum/excel-...two-dates.html

Yes I Need VBA solution pls

Please Login or Register  to view this content.

Try to work on this code. Edit some part so you can customized it to your project.

UDF
Use in cell like
=IFERROR(Months(A$1,A$2,ROW(A1)-1),"")
format the cell "mmm-yy" and copy down

Where;
A$1 = Starting date cell
A$2 = Ending Date cell
ROW(A1)-1 should not be touched.

Please Login or Register  to view this content.

Wow Both Tricks worked fantastic , Thank you jindon & oluapseyer

You are welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

you're welcome...