Display Day...
I thought of that, but there is no day format.
"Dave Peterson" wrote:
You could do it by:
=A1
and format it to show the day of the week.
But you could use a custom format for the original date:
mm/dd/yyyy dddd
GoodTrouble wrote:
I have a whole spreadsheet of dates that I have worked and related numbers.
The dates are in mm/dd/yy format. I would like in another colum to be able to
have those dates as the days they were...Such as Monday, Tuesday...etc... And
then I need to pull averages for each Monday, Tuesday...etc of each month...
Is this at all possible??
--
Dave Peterson
|