List missing months

[eduzs]

Hi there!
My spreadsheet has a long list of months in column X like:
Jan/20
mar/20
jul/20
aug/20
dec/20
I need a macro that goes from A1 to usedrange.rows.count, and list the missing months.
In the above example the result should be: (msgbox):
"feb/20, apr/20 to jun/20, sep/20 to nov/20"
Need help to do this.
Thanks.

 

[DanteAmor]

What do you have in the cells: have a date in "mmm/yy" format or do you have the text "Jan/20"?

 

[eduzs]

Thanks! I found a solution.