Pulling day, from a date string cell

[barnsey11]

I have probably a simple question, I have a list of dates just like below. What I need to pull from this is just the day. Is there a formula where I can ask is you pull just the day from the date sting I already have.


Tuesday, March 21, 2006
Tuesday, March 21, 2006
Wednesday, March 22, 2006
Wednesday, March 22, 2006
Thursday, March 23, 2006
Thursday, March 23, 2006
Thursday, March 23, 2006
Thursday, March 23, 2006
Friday, March 24, 2006
Friday, March 24, 2006
Saturday, March 25, 2006

Thanks in advance for your help

 

[Scott Huish]

=DAY(A1)

or to just display the day, format the cell as d

 

[barnsey11]

Thanks for your help, but it does not seem to work, I need it to bring over the day of the week ed Tuesday, instead its shoeing me the day as a numner eg 21st

 

[Andrew Poulsom]

If your dates are serial dates formatted as dddd, mmmm d, yyyy:

=A1

formatted as dddd will give just the day. If you want the day as a string rather than a serial date you can use:

=TEXT(A1,"dddd")

 

[barnsey11]

Thank you

Thank word you are MVP

Cheers, im actually from Preston