Results 1 to 3 of 3

Thread: Calendar based on Month selected
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2006
    Posts
    258
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Calendar based on Month selected

    Hello all,
    A1 on sheet Log, will be a Month and Year only (Mar 2019)
    A2 Should be first day of the month selected in A1,
    Col A will have all the next dates of the month until the last 31st

    But what I would like is if I select Feb 2019 in A1
    all the col A fill up until the 28th Feb (Cell A29) A30 should be blank and A31 should also be blank.
    Can someone help please.


    Cheers

  2. #2
    Board Regular Kenneth Hobson's Avatar
    Join Date
    Feb 2007
    Location
    Tecumseh, OK
    Posts
    3,079
    Post Thanks / Like
    Mentioned
    7 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Calendar based on Month selected

    A2= =A1, set custom number format to 2.
    A3= =IFERROR(IF(MONTH(A$1)=MONTH(A2+1), A2+1,""),""), and fill down to A31.

  3. #3
    Board Regular
    Join Date
    Dec 2006
    Posts
    258
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Calendar based on Month selected

    Perfect thank you very much

Some videos you may like

User Tag List

Tags for this Thread

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
  •