date and day formula, please help!

[pedie]

If value in cell A1 <TABLE style="WIDTH: 123pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=164 border=0><COLGROUP><COL style="WIDTH: 123pt; mso-width-source: userset; mso-width-alt: 5997" width=164><TBODY><TR style="HEIGHT: 12pt; mso-height-source: userset" height=16><TD class=xl66 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 123pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 12pt; BACKGROUND-COLOR: transparent" width=164 height=16>= Wednesday, July 21,2010
is there a formula to pull out just the day that will show wednesday in cell A2?

Thanks!

</TD></TR></TBODY></TABLE>

 

[Colin Legg]

If there is an actual date in A1, but that cell has been formatted to display it in that way, then this will work:

=TEXT(A1,"dddd")

 

[pedie]

Wow, great, thanks!!!
That work well! perfectly!

how do you know of this formula, i mean how do you came to know?

 

[Colin Legg]

Hi,

I can't really remember when or how I would have learnt that one. I guess it's just down to practice!

 

[pedie]

Okay..thanks anyways, thanks again!

 

[PCRIDE]

you can also use differnt combo's

MM/DD/YY would give you the date in this format 02/12/2010

or YYYY = 2010
MMMM = Month etc...