List of months between two dates entered in Excel

[jassi2006]

I just want to create list of months between two dates entered in Excel.

something like this

If given date in Cell A1 = 12-03-2020 and in Cell B1 = 25-06-2020

Then the result in Column A wanted to be as under
A2 12-03-2020 to 31-03-2020
A3 04-2020
A4 05-2020
A5 01-06-2020 to 25-06-2020

OR it may also be ok
A2 12-03-2020 to 31-03-2020
A3 01-04-2020 to 30-04-2020
A4 01-05-2020 to 31-05-2020
A5 01-06-2020 to 25-06-2020

 

[Trebor76]

Hi jassi2006,

Put this formula into cell A3 and copy down till it returns a blank (cell A5 in this case):

=IFERROR(IF(MONTH(A2)<MONTH($B$2)-1,TEXT(EOMONTH(A2,1),"mm-yyyy"),TEXT(DATE(YEAR($B$2),MONTH($B$2),1),"dd-mm-yyyy") & " to " & TEXT(EOMONTH($B$2,0),"dd-mm-yyyy")),"")

Regards,

Robert

 

[jassi2006]

Hi jassi2006,

Put this formula into cell A3 and copy down till it returns a blank (cell A5 in this case):

=IFERROR(IF(MONTH(A2)<MONTH($B$2)-1,TEXT(EOMONTH(A2,1),"mm-yyyy"),TEXT(DATE(YEAR($B$2),MONTH($B$2),1),"dd-mm-yyyy") & " to " & TEXT(EOMONTH($B$2,0),"dd-mm-yyyy")),"")

Regards,

Robert

Its not working sir.......

 

[jassi2006]

If possible please provide VBA Solution as I have data above and below calculation.

Thanks

 

[Trebor76]

Its not working sir

That's odd - it worked for me Make sure what's in cells A1 and B1 are actually dates not text (strings) that look like dates.

If possible please provide VBA Solution as I have data above and below calculation.

Need to determine the format of the dates first.