Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Help with Dates..

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

    Default

    Hi, I hope someone can help with this...

    If I have a month in one cell (eg. May), how can i get
    Excel to populate a column with the dates for that
    particular month..

    (Example:
    May <----User inputs

    Tuesday May 1 <-----Excel outputs
    Wednesday May 2 <-----Excel outputs
    ....
    ....)

    All the way to the end of the month..

    Any help with this is greatly appreciated!!!
    Thank-you
    Sean


  2. #2
    Board Regular zacemmel's Avatar
    Join Date
    Apr 2002
    Location
    Redmond, WA
    Posts
    636
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sean,

    You can probably do this with one formula, but I split it into 2 formulas in the interest of time.

    For the first date, use this formula (entered into b1):

    =datevalue(a1&" 2002")

    The second formula (in the cell below this one) would be:

    =b1+1

    The custom date format should be:

    ddd MMM dd

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Click on the cell then put you mouse pointer on the fill handle at the bottom of the cell. Now drag it down and the dates will follow..............

    Denny

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,743
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    with your date in e1, and starting in row1, you could use
    =IF(ISERR(($E$1&" "&ROW()&", "&YEAR(NOW()))+0),"",($E$1&" "&ROW()&", "&YEAR(NOW()))+0)

    next copy it down 31 rows.


    good luck

    [ This Message was edited by: IML on 2002-05-02 09:37 ]

  5. #5
    New Member
    Join Date
    May 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for the info...It really helped

    Thanks
    Sean

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
  •