software

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??

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:
gt;
gt; I have a whole spreadsheet of dates that I have worked and related numbers.
gt; The dates are in mm/dd/yy format. I would like in another colum to be able to
gt; have those dates as the days they were...Such as Monday, Tuesday...etc... And
gt; then I need to pull averages for each Monday, Tuesday...etc of each month...
gt;
gt; Is this at all possible??

--

Dave Peterson

I thought of that, but there is no day format.

quot;Dave Petersonquot; wrote:

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

To display the day the dates represent (assuming the date is in cell A1)

=VLOOKUP(WEEKDAY(A1),{1,quot;Sundayquot;;2,quot;Mondayquot;;3,quot;Tue sdayquot;;4,quot;Wednesdayquot;;5,quot;Thursdayquot;;6,quot;Fridayquot;;7,quot;Sat urdayquot;},2,FALSE)

Then copy it down as far as necessary.

To get an average for a particular day (say Friday) you could do something
like

SUMIF(C1:C5,quot;Fridayquot;,B1:B5)/COUNTIF(C1:C5,quot;Fridayquot;)

where C1:C5 contains the VLookup formulae above, B1:B5 contains the numeric
data you want averaged.quot;GoodTroublequot; wrote:

gt; I have a whole spreadsheet of dates that I have worked and related numbers.
gt; The dates are in mm/dd/yy format. I would like in another colum to be able to
gt; have those dates as the days they were...Such as Monday, Tuesday...etc... And
gt; then I need to pull averages for each Monday, Tuesday...etc of each month...
gt;
gt; Is this at all possible??

To display the date as Monday etc - use format cells \ custom \ type and
enter dddd

That should do it --quot;GoodTroublequot; wrote:

gt; I have a whole spreadsheet of dates that I have worked and related numbers.
gt; The dates are in mm/dd/yy format. I would like in another colum to be able to
gt; have those dates as the days they were...Such as Monday, Tuesday...etc... And
gt; then I need to pull averages for each Monday, Tuesday...etc of each month...
gt;
gt; Is this at all possible??

Nevermind the dddd worked...THANKS!

quot;Dave Petersonquot; wrote:

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

Thank You All!! Problem Solved!

quot;Florida Userquot; wrote:

gt; To display the date as Monday etc - use format cells \ custom \ type and
gt; enter dddd
gt;
gt; That should do it --
gt;
gt;
gt; quot;GoodTroublequot; wrote:
gt;
gt; gt; I have a whole spreadsheet of dates that I have worked and related numbers.
gt; gt; The dates are in mm/dd/yy format. I would like in another colum to be able to
gt; gt; have those dates as the days they were...Such as Monday, Tuesday...etc... And
gt; gt; then I need to pull averages for each Monday, Tuesday...etc of each month...
gt; gt;
gt; gt; Is this at all possible??