Help Need to convert a date to a day...then progressive through each days data

[DaveHampson]

Hi

I have a spreadsheet with 4 years worth of data already in it.

I have the date in column B...There are several lines with the same date for each day...then it moves to the next day...and so on

What I would like to do in column A is add a formula that works out the day for the date and places it in that cell A

So like today I have 36 lines with the same date in Column B
Today I could just add Friday to column A for all 36 lines

But I have actually 4 years worth of dates...and that would take a very long time to do manually

Any help would be much appreciated

Dave

[judgeh59]

I assume column A is empty....if it is this should work....assuming the column B dates are real XL dates...

Please Login or Register  to view this content.

[DaveHampson]

Thanks Ernest

Thats working apart from the day of the changed date is showing as the previous day....example

Friday 12/10/2012
Friday 12/10/2012
Friday 12/10/2012
Friday 13/10/2012
Saturday 13/10/2012
Saturday 13/10/2012
Saturday 13/10/2012
Saturday 13/10/2012


Dave

[judgeh59]

it works for me --- my first thought is that you may not be in row 1 when you start....adjust the first cell from B1 to whatever it starts....does that make sense

[DaveHampson]

Yep...that was the problem....the header was in the B1 column

Everything working fine.....quality stuff...thanks very much for a quick reply...much appreciated

[judgeh59]

my pleasure glad I could help....have a great day....

If this has been completed to your satisfaction, please set the thread to Solved...If you feel I deserve an increase in my reputation, feel free to click on the star in the lower left of the thread. Remember, someday when you help somebody they may add to your rep points, and it could be me...just a thought...

[DaveHampson]

Sorry...I'm new...no idea where I marked solved....I have had a look round but can't see anything. I know there must be something...

[judgeh59]

open the thread, select Thread Tools from the menu link above and mark this thread as SOLVED. thanks for the rep points

[Tony Valko]

=LOOKUP(WEEKDAY(B1),{1,2,3,4,5,6,7},{"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"})

This will do the same thing:

=TEXT(B1,"dddd")

[DaveHampson]

You are quite correct Tony......This is all above me....I would never have thought such a little formula would have done what was required...thanx

[Tony Valko]

You're welcome. Thanks for the feedback!