|If your data is in A1, |
in B1 enter the formula: =DAY(A1)
Then Custom format cell B1,
Select Number Tab,
In the Type box enter: ddd or dddd.
Three gives you the short day Sat
Four gives you the long day Saturday
You could also use the =TEXT() function to do the same thing.
With your data in cell A1
in cell B1 enter the formula: =TEXT(A1,"dddd")
as with the Custom Formatting,
Three d's gives you the short day Sat
Four d's gives you the long day Saturday
In both cases, drag the cell down as many rows as needed.