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

[Dagswe21]

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.

[Richard Buttrey]

Hello and welcome to the forum. Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Logit]

See attached:

Columns A & B have formulas for each cell as such -

Please Login or Register  to view this content.

I'm certain this is just one way of accomplishing your need. Hope this helps with your goal.

Cheers !

[Richard Buttrey]

See attached:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks for the response you have given.

[Richard Buttrey]

...and another variation

In B1 custom formatted with "dddd"

Please Login or Register  to view this content.

[Dagswe21]

Thank you to Logit, and Richard Buttrey for your replies. Looks like I got it now!

Cheers!

Dag.

[Logit]

Your welcome.