Changing calendar based on year with static days

Hello everyone,

i have a problem i'm working on, i have a calendar the row with the days of the week in row 5 are static and the months in column B are also static, based on a year dropdown in cell B2 the cell from C6:AM28 need to change according to the day and month within the matrix,

i have tried various methods but can only get the first month to work,

any ideas anyone??

thanks reg

I think this link can be very helpful for you a sit proved to me...

http://www.excelforum.com/excel-work...n-for-day.html

Hello reg,

I had to change columns A and B just to pick up the relevant year....then I put this formula in C6 copied across and down

=IF($B6="","",IF(OR(COLUMNS($C6:C6)=1,B6=""),IF(WEEKDAY($B6)=COLUMNS($C6:C6),$B6,""),IF(DAY(B6+1)=1,"",B6+1)))

see attached

thanks daddylonglegs

that works just fine

thanks very much

grr i just finished mine but dll is better! and i only did january!