Display Day...

[GoodTrouble]

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]

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

[GoodTrouble]

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
>

[GoodTrouble]

Nevermind the dddd worked...THANKS!

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

[JMB]

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

=VLOOKUP(WEEKDAY(A1),{1,"Sunday";2,"Monday";3,"Tuesday";4,"Wednesday";5,"Thursday";6,"Friday";7,"Saturday"},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,"Friday",B1:B5)/COUNTIF(C1:C5,"Friday")

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


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

[Florida User]

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

That should do it --


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

[GoodTrouble]

Thank You All!! Problem Solved!

"Florida User" wrote:

> To display the date as Monday etc - use format cells \ custom \ type and
> enter dddd
>
> That should do it --
>
>
> "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??