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

Thread: FORMATING OF DATE

  1. #1
    Guest

    Default

    I have a list of few hundred clients addresses and their date-of-birth and I wish to format the birthday column to reflect the year of birth to 2002 so that I can do sorting by month (use for mail merging and sending out birthday cards)

    EG:
    3-Mar-1946
    18-May-1957
    28-Sept-1967

    To be formated to:
    3-Mar-2002
    18-May-2002
    28-Sept-2002

    Which formula should I use and how should the formula be keyed in.

    Any help will be appreciated.

    Thanks

    Ricky
    rlimlm@yahoo.com

  2. #2
    Board Regular Steve Hartman's Avatar
    Join Date
    Feb 2002
    Location
    Houston,Texas
    Posts
    417
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If your dates are in column A:

    =DATE(2002,MONTH(A1),DAY(A1))

    in another column and pasted down will do the trick. Of course format this column as date
    Veni, Vidi, Velcro - I came, I saw, I stuck around

    Taxation WITH representation ain't so hot either

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
  •