+ Reply to Thread
Results 1 to 8 of 8

Trying to make a calendar in multiple columns and rows together

  1. #1
    Registered User
    Join Date
    10-12-2013
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    30

    Trying to make a calendar in multiple columns and rows together

    is there any way to make a calendar with the month being in a 7x7 grid instead of the month in a straight line. the attacked file is what i am looking for. if this is not possible i can use the other way.

    Jewish Calender.xls
    Last edited by eaglewolf573; 11-29-2013 at 12:22 AM.

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Making a Calendar

    What determines the length of the month (name or something else) ?
    I see a "blank" month...whats this represent?
    I also see several sheets worth of calendars, how do these apply to your request?
    something that shows your expected results, and why that should be the expected result would definitely help
    (I am a native american cross-bred european, and do not pay much attention to religion, so if my questions are offensive, I apologize in advance, but, answers would be helpful )
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,044

    Re: Making a Calendar

    Not sure if this is relevant to you or not,but take a look...
    http://hebrew-calendar.software.informer.com/9.1/

    You could just google excel jewish calendars and take a look at some of the links there? (thats what I did to find that link)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    10-12-2013
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Making a Calendar

    i have found in my research that the jewish calender today is accually wrong. so i am making my own.

    the number of days in the month is determined by the lunar cycle, new moon to new moon. the blank month is a 13th month to get that calendar set right with the solar calendar. in a 19 year cycle the 3, 6, 9, 11, 14, 17, and 19 years are leap years with the 13th month. the extra sheets where made before i found out that this formula was wrong. they gave a way to come back to the beginning of the 19 year cycle that would start on a sunday and end on a saturday.

  5. #5
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: Making a Calendar

    and , what would you expect to see? ( and BTW, your title has very little to do with this, I would suggest changing it to something more meaningful, Ihave created a few calendar sheets, and this is nothing I've seen before )

  6. #6
    Registered User
    Join Date
    10-12-2013
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: How do i make a calendar as a grid.

    each one of the calenders (1 of 19 B, 2 of 19 B, ect.) is on one sheet of paper when printed out.

  7. #7
    Registered User
    Join Date
    10-12-2013
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: How do i make a calendar as a grid.

    see attachment as to what i am looking for.

    Jewish Calender2.xls

  8. #8
    Registered User
    Join Date
    10-12-2013
    Location
    Pennsylvania, USA
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Trying to make a calendar in multiple columns and rows together

    any more help here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Making Calendar
    By oskar270 in forum Excel General
    Replies: 47
    Last Post: 06-02-2013, 10:59 AM
  2. [SOLVED] Making calendar dates specific to a pattern
    By bcn1988 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-25-2013, 09:09 AM
  3. Help in making a calendar with option to mark against each date
    By Parv in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-20-2012, 05:53 AM
  4. Question about making calendar with VBA
    By simoandr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2012, 10:35 AM
  5. [SOLVED] Making calendar with numbers and text in same cell
    By yankeybeans in forum Excel General
    Replies: 0
    Last Post: 10-13-2005, 03:05 PM

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