+ Reply to Thread
Results 1 to 5 of 5

Changing calendar based on year with static days

  1. #1
    Forum Contributor
    Join Date
    11-23-2007
    Location
    Suffolk, UK
    Posts
    298

    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
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2016
    Posts
    2,218

    Go thru this link

    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

  3. #3
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676
    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
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    11-23-2007
    Location
    Suffolk, UK
    Posts
    298
    thanks daddylonglegs

    that works just fine

    thanks very much

  5. #5
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320
    grr i just finished mine but dll is better! and i only did january!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1