Results 1 to 7 of 7

How do I return ONLY the name of a weekday, from a cell/cells containing that day's date,

Threaded View

  1. #1
    Registered User
    Join Date
    11-01-2016
    Location
    London, U.K.
    MS-Off Ver
    Office for iPad Pro.
    Posts
    2

    Red face How do I return ONLY the name of a weekday, from a cell/cells containing that day's date,

    Hello Everyone. I am new to this Forum, and this is my first ever post. As my Profile says, I used MS Office for a number of years during my work in admin and finance. However this ended in about 2008 I think, and I have become VERY rusty!!! So I need help with the following. Please don't laugh!! But, It may be THE easiest question ever posted!! A few years ago I would have done this "in my sleep", but I'm sooooo rusty that I just can't figure it out now!!

    Though it is so simple, it is a part of something very important to me, which I MUST get right, so all your help is really appreciated!!! Thank you in advance.

    My question:

    I am starting from a blank worksheet. In one column (let's say Column A) I have today's date, 01/11/2016 (I'm using the U.K. Date Format, so 1st November, 2016). I need this to go down the rows, adding three days each time (so 4th November in Row 2, 7th November in Row 3, etc. I just did (= A2=(A1+3) etc., and did copy/paste for about 20 rows. Perfect, no probs so far!!).

    NOW, in Column B, alongside each date, ALL I want it to return, is, which day of the week will this be? So next to 01/11/2016 i need just the word "Tuesday", and so on down the column.

    Obviously I could just re-format the column to show "Tuesday, 1st November 2016" and so on, but, I need it just as described above: Column A: 01/11/16, 04/11/16 etc. Column B, JUST the correct word: Tuesday, then next row, Friday, and so on, no showing the whole date. I could do it manually I guess, but I will have loads of rows in the end!!

    There - I did warn it was absurdly simple (at least I hope!!).

    All help/suggestions are greatly appreciated!!!

    Thank you.

    Dag.
    Last edited by Dagswe21; 11-01-2016 at 04:45 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. New to Excel,maybe its an easy question.
    By liviunn in forum Excel General
    Replies: 2
    Last Post: 01-21-2016, 07:14 PM
  2. [SOLVED] Easy question about Objects in VBA for Excel
    By saurabhmangal in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2014, 06:02 AM
  3. Easy Excel Question
    By czah7 in forum Excel General
    Replies: 3
    Last Post: 11-15-2011, 03:01 AM
  4. easy excel question
    By ness80 in forum Excel General
    Replies: 5
    Last Post: 01-22-2007, 02:05 PM
  5. important and probably easy to solve
    By Marco Santos in forum Excel General
    Replies: 1
    Last Post: 11-27-2006, 06:08 AM
  6. ***Important*** Question about check boxes
    By Excel-User in forum Excel General
    Replies: 3
    Last Post: 08-16-2006, 08:30 AM
  7. [SOLVED] Easy Excel VB question (I think!)
    By Just Kev in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-02-2006, 10:00 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1