Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Calendar

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    How do I get the following formula to display a calendar?

    {=if(month(date(d2,b2,1))<>month(date(d2,b2,1)-(weekday(date(d2,b2,1))-1)+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1,"",date(d2,b2,1-(weekday(date(d2,b2,1))-1+{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)}

    d2 is the year and b2 is the month

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,423
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    review John Walkenbach's site.
    He has an excellent example.

    http://j-walk.com/ss/

    Advise if this does not help.

    There are errors in the array formula that you provided; but I did not edit it. Missing brackets and function names.

    I removed the {} and then entered it with Ctrl-Shift-Enter.



    [ This Message was edited by: Dave Patton on 2002-03-30 12:03 ]

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Calgary, Alberta Canada
    Posts
    3,423
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    To use Mr. John Walkenbach's formula,
    - create the named ranges and named formulas
    - select A2:G6 and Array Enter the formula

    =IF(MONTH(Startdate)<>MONTH(Startdate-StartDOW+week*7+weekday-1),"",Startdate-StartDOW+week*7+weekday-1)

    - Number Format custom d

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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