Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Day...
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?? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Day...
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Day...
To display the day the dates represent (assuming the date is in cell A1)
=VLOOKUP(WEEKDAY(A1),{1,"Sunday";2,"Monday";3,"Tue sday";4,"Wednesday";5,"Thursday";6,"Friday";7,"Sat urday"},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?? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Day...
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?? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Day...
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display Day...
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?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to display results to certain number of significant figures | Excel Discussion (Misc queries) | |||
I don't want to display any controls in excel. | Excel Discussion (Misc queries) | |||
How do you display Greek and Russian languages in excel? | Excel Discussion (Misc queries) | |||
Conditional display of a .jpeg file? | Excel Discussion (Misc queries) | |||
Combine & Display “Fixed” & “Automatically Updated” Date Parts | Excel Worksheet Functions |