+ Reply to Thread
Results 1 to 6 of 6

How to find out day with respect to date in other column

  1. 06-19-2012, 02:35 PM #1
    shaileshgavanang
    shaileshgavanang is offline
    Registered User
    Join Date
    06-15-2012
    Location
    united arab emirates
    MS-Off Ver
    Excel 2007
    Posts
    45

    How to find out day with respect to date in other column

    Hi,

    i have date in one column and day in other column.

    i want to find out day automaticaly if i enter date in other.

    sample xls attached.

    thank you,
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-19-2012, 02:44 PM #2
    SteveG
    SteveG is offline
    Valued Forum Contributor
    Join Date
    03-25-2004
    Location
    Boston, MA US
    Posts
    1,094

    Re: How to find out day with respect to date in other column

    Hi,

    In B6:

    =CHOOSE(WEEKDAY(A6),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday")

    Copy down as needed.

    HTH
    Steve
    Reply With QuoteRegister To Reply
  3. 06-19-2012, 02:46 PM #3
    Søren Larsen
    Søren Larsen is offline
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: How to find out day with respect to date in other column

    Try this in B6:

    =TEXT(WEEKDAY(A6),"dddd") and copy down.?
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"
    Reply With QuoteRegister To Reply
  4. 06-19-2012, 02:48 PM #4
    SteveG
    SteveG is offline
    Valued Forum Contributor
    Join Date
    03-25-2004
    Location
    Boston, MA US
    Posts
    1,094

    Re: How to find out day with respect to date in other column

    Forgot about Loren's solution. Much less to type

    Steve
    Reply With QuoteRegister To Reply
  5. 06-19-2012, 02:48 PM #5
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: How to find out day with respect to date in other column

    just put =a6 in b6 and format cell DDDD
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  6. 06-19-2012, 02:56 PM #6
    shaileshgavanang
    shaileshgavanang is offline
    Registered User
    Join Date
    06-15-2012
    Location
    united arab emirates
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: How to find out day with respect to date in other column

    Hi all,

    thank all above solutions are working.

    thanks for your swift reply
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1