Build Dynamic Calendar: Select Month using Dropdown List

[jdppep]

I am attempting to build a calendar without VBA or array formulas. I have successfully created a calendar using dummy cells; however, am trying to write formulas which would not require these dummy cells.

The formula which works, but requires dummy cells (in orange):
=IF(MONTH(COLUMNS($B4:B4)+(ROWS(B$4:B4)-1)*7-$N$4+$N$3)=$N$5,COLUMNS($B4:B4)+(ROWS(B$4:B4)-1)*7-$N$4+$N$3,"")

I have attempted:
=IF(MONTH(COLUMNS($B4:B4)+(ROWS(B$4:B4)-1)*7-WEEKDAY($B$2,1)+DATE(YEAR($B$2),MONTH($B$2),1)=MONTH($B$2),COLUMNS($B4:B4)+(ROWS(B$4:B4)-1)*7-WEEKDAY($B$2,1)+DATE(YEAR($B$2),MONTH($B$2),1)),"")

Please see attachment for an example.

Thank you!

 

[SirJB7]

Hi, jdppep!
Check this:
http://chandoo.org/wp/2012/12/26/download-free-2013-calendar/
If you haven't received it by mail, then join the newsletter at the home page.
Regards!