A month's calender based on a caell value

Hi all

Is it possible to populate the cells with a months' calender based on a date entered in a cell (say A1). If A1 is march 2015, then cells should get March 2015 Calender. If April 2015, then April 2015 calender and so on.

Can the current day be highlighted dynamically each day?

I have attached a sample workbook where in Cell A1 has the date and the month calender beside it. I did this manually but if a Vb code can be written, then it would save me lots of work each month.

Help me save lots of sweat frndz.

@smb_146

yeah, that seems to work but as long as month is in March, days are constant but when I change month days stat moving.

Anyway that was a relief u replied.

Thanks mate. Do look into the issue.

@ AkaTrouble....that was fun....it is all I wanted. Thanks mate.

I have a holidays list and named that range (c1:c25) as HOLIDAYS. Can I highlight those days using conditional formatting. if yes, what would be syntax??