Excel calendar based on month and Year

[Pavan.Sada.PS]

Dear friends,

Request you to please help me to create calendar based on the month and year..

 

[Mike H..]

Dear friends,

Request you to please help me to create calendar based on the month and year..

Hi,

Your workbook crashes my PC when I enable editing so I can't upload it as a working version. Put this; rather long, formula in B2 and drag right and down to fill all the cells in your calendar.
It works based on the month and year in the dropdowns in I1 & I2

=IF(MONTH(COLUMNS($B2:B2)+(ROWS(B$2:B2)-1)*7-WEEKDAY(EOMONTH(VALUE(1&$I$1&$I$2),-1)+1)+EOMONTH(VALUE(1&$I$1&$I$2),-1)+1)=MONTH(EOMONTH(VALUE(1&$I$1&$I$2),-1)+1),COLUMNS($B2:B2)+(ROWS(B$2:B2)-1)*7-WEEKDAY(EOMONTH(VALUE(1&$I$1&$I$2),-1)+1)+EOMONTH(VALUE(1&$I$1&$I$2),-1)+1,"")

 

[Pavan.Sada.PS]

Hello Mike,

Not sure whats wrong with the file, its working fine with me. Any How thanks for the formula.. It worked well..

 

[Mike H..]

Dear friends,

Request you to please help me to create calendar based on the month and year..

Hi,

With macros disabled I was able to update your workbook. See attached.