Day of the week Pivot?

[kizzie37]

Cant seem to get my head around how to get this to work

I have entries in an excel date, I have extracted the day of the week that the event occurred.

I need a pivot table to how many times the event occured on say mondays, tuesdays etc.

Cant seem to make it work, its treating the days like dates, stuck on how to get the number of events on a each day of the week, to date.

any suggestions?

 

[Saagar]

What function did you use to convert the date to day of week?

If you use =weekday(date), it will convert to a number 1 thru 7. You can do a pivot with weekday on column field.

 

[kizzie37]

Saagar, thanks sooo much, I just could not get my head around how to do it, works perfectly!!

 

[kizzie37]

incidentally when i display the results of the pivot in a table though, the day reverts back to a number, I cant seem to change it to text? I am using 2010

 

[water1355]

I use =text(date,"ddd") to generate the day of the week as a text string instead of =weekdate(date) which returns a number.

 

[water1355]

Try =text(date,"ddd")