Results 1 to 3 of 3

Thread: Formula Based Excel Calendar With Custom Start Month

  1. #1
    Junior Member
    Join Date
    Oct 2013
    Posts
    4
    Rep Power
    0

    Formula Based Excel Calendar With Custom Start Month

    Hello Experts,
    I am working on a Microsoft Excel Calendar template.
    but have added a few modifications of my own.

    The original template only came with a year that you can change, the months are Jan thru Dec for the same year.
    I have added a month selector, and want the calendar to always start with the month and year going forward 12 months.
    please see attached file.
    I got the month and year to appear correctly.
    but could not get the formula for the dates on the calendar to work.
    have been working on this for 2 days already.

    Any help would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Here's one way of doing it.
    Attached Files Attached Files
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Junior Member
    Join Date
    Oct 2013
    Posts
    4
    Rep Power
    0
    That is exactly what I am looking for.
    Thank you very much Excel Fox...

Similar Threads

  1. Replies: 13
    Last Post: 07-08-2013, 10:34 AM
  2. Replies: 5
    Last Post: 06-15-2013, 12:40 PM
  3. How To Make A Calendar In Excel Using Formula
    By rich_cirillo in forum Excel Help
    Replies: 6
    Last Post: 03-26-2013, 07:21 PM
  4. Formula to Display Month and Dates Using Spin Button
    By ayazgreat in forum Excel Help
    Replies: 6
    Last Post: 11-21-2012, 10:19 PM
  5. Custom Spin Button Based On Values Passed From Array
    By Preeti Verma in forum Excel Help
    Replies: 7
    Last Post: 05-22-2012, 07:23 PM

Posting Permissions

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