Create automatic calendar

Thanks Martin and outofthehat for your quick replies. Both great ideas. I can quickly see that outofthehat's suggestion seems to work, if I can then get the formatting the way I want it, which I think I can do. But I want to explore Martin's idea, too. I haven't done any macros, so I'll be swimming in dangerous waters - but it might be a good time to try.

Profile updated, outofthehat - thanks for the reminder!

I appreciate immensely the sharing the sharing of knowledge here!!

Improvement - make that top-left cell of the calendar

=L1-H1+1

Gets rid of the unnecessary IF...

Trying to figure something out
Will post if I can come up either something