Display Monday or Thursday
Select one of the cells and click Format | Cells | Number (tab) |
Custom and enter this in the panel:
mm/dd/yyyy (Dddd)
and click OK. If this is what you want then you can use the Format
Painter to apply the format to your other cells.
Hope this helps.
Pete
On Jan 29, 8:01 pm, "Deb" wrote:
How do I display Monday or Thursday?
I have a column with the dates listed on the left a, on the right I'm
attemtping to display either Monday or Thursday.
3/16/2007 display 03/19/2007 (Monday)
2/10/2007 display 02/12/2007 (Monday)
4/3/2007 display 04/05/2007 (Thursday)
Thanks for your assistance
|