Just use a formula and then custom format your cell. For example, if your date is in cell A1, use =A1. Custom format your cell with the formula to "dddd" (minus the quotation marks). To custom format, select Format|Cells and choose "Custom" in the category box in the Number tab. Put "dddd" in the Type box.On 2002-04-04 14:55, mrs peel wrote:
Maybe I'm daft, but here's my no-such-thing-as-a-stupid question:
If I enter a date (d/m/y) in a cell, can I automatically display (in a different cell) the DAY of that date?
Told you I was a novice.
Cheers (and thanks)!
Anno, are you sure you didn't copy my answer?On 2002-04-04 15:03, anno wrote:
sorry barry - didn't see your post when i dove in