Changing from a date to a day

[jzollars]

I searched on the site for some time regarding this question and could not find anything.

So basically what I need is to refelct a date in one cell (6/30/2009) to the corrisponding day in another cell (Tuesday).

I know that the formatting tool will allow you to shoot back Tuesday, June 30, 2009 but i simply need to extract the Tuesday.

 

[Kelbo]

Format the cell with the date (or in an adjacent cell copy the date) as:

Format Cells - Custom -

and enter dddd in the custom area.

Kelbo

 

[jzollars]

Perfect. Extremely easy.

 

[texasalynn]

or another way put in another cell the formula
=text(a1,"dddd")